PREVIEW / etf_30min / 2021-09-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-27.parquet
  size:    619 KB
  rows:    23,788

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-09-27 04:00:00	SPY	ETF	445.02	445.23	444.96	445.14	10782.0
2021-09-27 04:30:00	SPY	ETF	445.13	445.23	445.03	445.2	7696.0
2021-09-27 05:00:00	SPY	ETF	445.3	445.53	445.18	445.18	15020.0
2021-09-27 05:30:00	SPY	ETF	445.08	445.16	444.28	444.28	10025.0
2021-09-27 06:00:00	SPY	ETF	444.28	444.46	444.02	444.29	13175.0
2021-09-27 06:30:00	SPY	ETF	444.17	444.19	443.55	443.58	28525.0
2021-09-27 07:00:00	SPY	ETF	443.58	443.78	443.2	443.5	54377.0
2021-09-27 07:30:00	SPY	ETF	443.55	443.72	443.45	443.52	26401.0
2021-09-27 08:00:00	SPY	ETF	443.44	446.14	442.37	442.5	354143.0
2021-09-27 08:30:00	SPY	ETF	442.43	443.27	442.19	442.96	344552.0
2021-09-27 09:00:00	SPY	ETF	442.96	443.03	442.5	442.82	238268.0
2021-09-27 09:30:00	SPY	ETF	442.81	443.29	441.9	442.9	7070564.0
2021-09-27 10:00:00	SPY	ETF	442.89	443.83	442.44	443.82	3825600.0
2021-09-27 10:30:00	SPY	ETF	443.8292	444.05	443.16	443.18	2980509.0
2021-09-27 11:00:00	SPY	ETF	443.17	443.83	442.89	443.06	2436190.0
2021-09-27 11:30:00	SPY	ETF	443.065	443.24	442.31	442.74	2607241.0
2021-09-27 12:00:00	SPY	ETF	442.74	443.31	442.41	443.07	1917361.0
2021-09-27 12:30:00	SPY	ETF	443.07	443.07	442.07	442.32	2178377.0
2021-09-27 13:00:00	SPY	ETF	442.31	443.17	442.14	443.09	2044975.0
2021-09-27 13:30:00	SPY	ETF	443.09	443.43	442.76	443.4	1584989.0
2021-09-27 14:00:00	SPY	ETF	443.4	443.72	443.27	443.6599	1626447.0
2021-09-27 14:30:00	SPY	ETF	443.655	443.69	443.13	443.22	1645979.0
2021-09-27 15:00:00	SPY	ETF	443.21	443.68	443.045	443.25	2832865.0
2021-09-27 15:30:00	SPY	ETF	443.26	443.475	442.32	442.68	9284338.0
2021-09-27 16:00:00	SPY	ETF	442.67	442.71	442.23	442.41	3056469.0
2021-09-27 16:30:00	SPY	ETF	442.4	442.64	442.27	442.31	245525.0
2021-09-27 17:00:00	SPY	ETF	442.36	442.64	442.2	442.35	122809.0
2021-09-27 17:30:00	SPY	ETF	442.35	442.35	442.22	442.32	19750.0
2021-09-27 18:00:00	SPY	ETF	442.33	442.56	442.3	442.46	60269.0
2021-09-27 18:30:00	SPY	ETF	442.64	442.64	441.93	441.95	37747.0
2021-09-27 19:00:00	SPY	ETF	442.03	442.32	442.01	442.12	12602.0
2021-09-27 19:30:00	SPY	ETF	442.31	442.65	442.31	442.33	27689.0
2021-09-27 04:00:00	QQQ	ETF	373.8	373.93	373.62	373.74	13475.0
2021-09-27 04:30:00	QQQ	ETF	373.67	373.75	373.53	373.61	6909.0
2021-09-27 05:00:00	QQQ	ETF	373.63	373.86	373.25	373.25	15585.0
2021-09-27 05:30:00	QQQ	ETF	373.24	373.24	372.25	372.33	48908.0
2021-09-27 06:00:00	QQQ	ETF	372.22	372.65	372.13	372.29	45702.0
2021-09-27 06:30:00	QQQ	ETF	372.29	372.32	371.13	371.47	306370.0
2021-09-27 07:00:00	QQQ	ETF	371.5	371.77	371.0	371.25	218899.0
2021-09-27 07:30:00	QQQ	ETF	371.25	371.51	371.17	371.34	104037.0
2021-09-27 08:00:00	QQQ	ETF	371.3	374.84	370.09	370.29	594971.0
2021-09-27 08:30:00	QQQ	ETF	370.32	370.84	369.48	370.5	539907.0
2021-09-27 09:00:00	QQQ	ETF	370.5	370.53	369.88	370.2	289238.0
2021-09-27 09:30:00	QQQ	ETF	370.2	370.89	367.73	368.66	6541241.0
2021-09-27 10:00:00	QQQ	ETF	368.68	370.32	368.14	370.32	3828316.0
2021-09-27 10:30:00	QQQ	ETF	370.3101	370.7	369.99	369.99	2229083.0
2021-09-27 11:00:00	QQQ	ETF	369.98	371.07	369.63	369.74	2197438.0
2021-09-27 11:30:00	QQQ	ETF	369.75	370.02	368.78	369.34	2205597.0
2021-09-27 12:00:00	QQQ	ETF	369.32	369.85	368.89	369.6499	1449209.0
2021-09-27 12:30:00	QQQ	ETF	369.63	369.67	368.6	369.08	1507279.0

> showing 50 of 23,788 rows — these rows as CSV

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