PREVIEW / etf_30min / 2021-10-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-08.parquet
  size:    602 KB
  rows:    22,842

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2021-10-08 04:00:00	SPY	ETF	438.66	438.83	438.4	438.55	20253.0
2021-10-08 04:30:00	SPY	ETF	438.66	438.66	437.88	437.97	31752.0
2021-10-08 05:00:00	SPY	ETF	437.87	438.18	437.8	437.99	11631.0
2021-10-08 05:30:00	SPY	ETF	438.0	438.61	437.96	438.61	20326.0
2021-10-08 06:00:00	SPY	ETF	438.57	438.87	438.55	438.87	15314.0
2021-10-08 06:30:00	SPY	ETF	438.89	439.05	438.66	438.66	19739.0
2021-10-08 07:00:00	SPY	ETF	438.84	439.23	438.84	439.23	61933.0
2021-10-08 07:30:00	SPY	ETF	439.2	439.2	438.92	438.98	124772.0
2021-10-08 08:00:00	SPY	ETF	438.99	439.93	438.6	439.31	264153.0
2021-10-08 08:30:00	SPY	ETF	439.45	440.34	437.84	439.58	2096662.0
2021-10-08 09:00:00	SPY	ETF	439.69	440.09	438.66	439.49	353554.0
2021-10-08 09:30:00	SPY	ETF	439.48	439.89	437.97	438.37	7939699.0
2021-10-08 10:00:00	SPY	ETF	438.37	439.7	438.33	438.98	4467792.0
2021-10-08 10:30:00	SPY	ETF	438.98	439.37	438.0401	438.74	4085789.0
2021-10-08 11:00:00	SPY	ETF	438.74	439.41	438.3	439.0	2807413.0
2021-10-08 11:30:00	SPY	ETF	439.01	439.095	438.21	438.345	2155478.0
2021-10-08 12:00:00	SPY	ETF	438.35	438.67	437.81	437.87	2601718.0
2021-10-08 12:30:00	SPY	ETF	437.86	438.67	437.78	438.2	2514122.0
2021-10-08 13:00:00	SPY	ETF	438.2	438.4199	437.19	437.48	2806425.0
2021-10-08 13:30:00	SPY	ETF	437.46	438.12	437.285	438.06	2319955.0
2021-10-08 14:00:00	SPY	ETF	438.05	439.2001	437.975	439.17	2849854.0
2021-10-08 14:30:00	SPY	ETF	439.17	439.31	438.63	438.73	2183060.0
2021-10-08 15:00:00	SPY	ETF	438.73	439.14	438.61	438.85	2680660.0
2021-10-08 15:30:00	SPY	ETF	438.84	438.9	437.48	437.83	10127832.0
2021-10-08 16:00:00	SPY	ETF	437.83	438.5268	437.23	437.38	2836953.0
2021-10-08 16:30:00	SPY	ETF	437.4	437.86	437.34	437.6	213065.0
2021-10-08 17:00:00	SPY	ETF	437.6	438.5775	434.8734	437.45	1124874.0
2021-10-08 17:30:00	SPY	ETF	437.455	437.49	437.29	437.36	31401.0
2021-10-08 18:00:00	SPY	ETF	437.33	437.45	437.33	437.44	9674.0
2021-10-08 18:30:00	SPY	ETF	437.45	437.45	437.22	437.25	22423.0
2021-10-08 19:00:00	SPY	ETF	437.32	437.37	437.25	437.33	5787.0
2021-10-08 19:30:00	SPY	ETF	437.33	437.39	437.3	437.35	17743.0
2021-10-08 04:00:00	QQQ	ETF	362.33	362.56	362.13	362.28	45555.0
2021-10-08 04:30:00	QQQ	ETF	362.37	362.38	361.84	361.94	26748.0
2021-10-08 05:00:00	QQQ	ETF	361.94	362.16	361.85	362.11	26811.0
2021-10-08 05:30:00	QQQ	ETF	362.01	362.75	362.01	362.74	21208.0
2021-10-08 06:00:00	QQQ	ETF	362.76	362.85	362.46	362.75	23366.0
2021-10-08 06:30:00	QQQ	ETF	362.84	362.93	362.68	362.68	7644.0
2021-10-08 07:00:00	QQQ	ETF	362.7	363.36	362.7	363.36	124635.0
2021-10-08 07:30:00	QQQ	ETF	363.36	363.41	363.14	363.28	26646.0
2021-10-08 08:00:00	QQQ	ETF	362.9999	363.9	361.99	363.56	118808.0
2021-10-08 08:30:00	QQQ	ETF	363.36	365.6	362.9	364.92	1645808.0
2021-10-08 09:00:00	QQQ	ETF	364.92	365.05	364.01	364.13	340630.0
2021-10-08 09:30:00	QQQ	ETF	364.1	364.3166	361.95	362.04	5579509.0
2021-10-08 10:00:00	QQQ	ETF	362.01	363.4999	361.9905	363.06	2857586.0
2021-10-08 10:30:00	QQQ	ETF	363.07	363.3	361.22	362.08	2793664.0
2021-10-08 11:00:00	QQQ	ETF	362.08	362.67	361.6415	362.02	2016483.0
2021-10-08 11:30:00	QQQ	ETF	362.01	362.13	361.05	361.4106	2046375.0
2021-10-08 12:00:00	QQQ	ETF	361.44	361.88	361.1513	361.3	1531649.0
2021-10-08 12:30:00	QQQ	ETF	361.28	362.24	361.2	361.6199	1540590.0

> showing 50 of 22,842 rows — these rows as CSV

> unlock the full archive -- $79 one-time