PREVIEW / etf_30min / 2021-10-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-01.parquet
  size:    635 KB
  rows:    24,329

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-01 04:00:00	SPY	ETF	427.22	427.85	426.1	426.7	65834.0
2021-10-01 04:30:00	SPY	ETF	426.7	427.07	426.29	426.48	33214.0
2021-10-01 05:00:00	SPY	ETF	426.69	427.21	426.68	427.16	29687.0
2021-10-01 05:30:00	SPY	ETF	427.29	427.29	426.72	426.95	13952.0
2021-10-01 06:00:00	SPY	ETF	427.02	427.7	426.96	427.3	34384.0
2021-10-01 06:30:00	SPY	ETF	427.47	427.89	427.22	427.89	163812.0
2021-10-01 07:00:00	SPY	ETF	427.86	430.1	427.84	429.96	562225.0
2021-10-01 07:30:00	SPY	ETF	429.94	431.33	429.85	430.6	789660.0
2021-10-01 08:00:00	SPY	ETF	430.65	431.51	425.65	431.45	813855.0
2021-10-01 08:30:00	SPY	ETF	431.49	431.51	430.03	430.42	803429.0
2021-10-01 09:00:00	SPY	ETF	430.48	431.17	429.14	430.98	470366.0
2021-10-01 09:30:00	SPY	ETF	430.98	431.61	428.8	429.41	10171901.0
2021-10-01 10:00:00	SPY	ETF	429.4	430.319	427.25	427.68	11008101.0
2021-10-01 10:30:00	SPY	ETF	427.68	429.248	427.23	429.19	7812743.0
2021-10-01 11:00:00	SPY	ETF	429.18	430.98	428.28	430.42	7071341.0
2021-10-01 11:30:00	SPY	ETF	430.41	432.1	430.36	431.44	5813384.0
2021-10-01 12:00:00	SPY	ETF	431.44	431.8	430.75	431.55	3888271.0
2021-10-01 12:30:00	SPY	ETF	431.56	431.95	431.16	431.43	2875437.0
2021-10-01 13:00:00	SPY	ETF	431.43	432.46	430.99	432.21	3628879.0
2021-10-01 13:30:00	SPY	ETF	432.21	433.89	432.21	433.295	5270608.0
2021-10-01 14:00:00	SPY	ETF	433.29	434.33	433.29	434.03	4769793.0
2021-10-01 14:30:00	SPY	ETF	434.044	434.93	433.95	434.755	4395711.0
2021-10-01 15:00:00	SPY	ETF	434.755	436.0329	434.755	434.85	6190253.0
2021-10-01 15:30:00	SPY	ETF	434.85	435.38	433.57	434.19	16733399.0
2021-10-01 16:00:00	SPY	ETF	434.18	434.76	433.88	434.44	4930180.0
2021-10-01 16:30:00	SPY	ETF	434.42	434.67	434.24	434.58	308305.0
2021-10-01 17:00:00	SPY	ETF	434.59	435.0	434.59	434.85	122415.0
2021-10-01 17:30:00	SPY	ETF	434.87	434.98	434.67	434.78	51665.0
2021-10-01 18:00:00	SPY	ETF	434.8	434.94	434.75	434.84	28977.0
2021-10-01 18:30:00	SPY	ETF	434.81	434.95	434.81	434.95	5763.0
2021-10-01 19:00:00	SPY	ETF	434.95	434.99	434.89	434.89	7918.0
2021-10-01 19:30:00	SPY	ETF	434.92	434.95	434.8	434.88	12844.0
2021-10-01 04:00:00	QQQ	ETF	356.75	356.75	355.8	356.19	45608.0
2021-10-01 04:30:00	QQQ	ETF	356.22	356.38	355.45	355.7	59987.0
2021-10-01 05:00:00	QQQ	ETF	355.8	356.29	355.8	356.2	38320.0
2021-10-01 05:30:00	QQQ	ETF	356.24	356.44	356.0	356.3	24784.0
2021-10-01 06:00:00	QQQ	ETF	356.46	356.75	356.23	356.46	19413.0
2021-10-01 06:30:00	QQQ	ETF	356.58	356.93	356.21	356.9	67546.0
2021-10-01 07:00:00	QQQ	ETF	356.89	358.85	356.89	358.739	246307.0
2021-10-01 07:30:00	QQQ	ETF	358.69	359.21	358.5	358.72	263375.0
2021-10-01 08:00:00	QQQ	ETF	358.7899	359.36	354.88	359.21	496239.0
2021-10-01 08:30:00	QQQ	ETF	359.13	359.14	357.85	358.4	543222.0
2021-10-01 09:00:00	QQQ	ETF	358.42	358.9	357.96	358.56	256770.0
2021-10-01 09:30:00	QQQ	ETF	358.6	359.18	356.03	356.61	5812064.0
2021-10-01 10:00:00	QQQ	ETF	356.59	356.9499	354.48	354.69	5579395.0
2021-10-01 10:30:00	QQQ	ETF	354.685	356.45	354.38	356.41	3690705.0
2021-10-01 11:00:00	QQQ	ETF	356.4	357.89	355.52	357.4893	3700792.0
2021-10-01 11:30:00	QQQ	ETF	357.49	358.54	357.37	358.09	2435072.0
2021-10-01 12:00:00	QQQ	ETF	358.106	358.31	357.1	357.7601	2492870.0
2021-10-01 12:30:00	QQQ	ETF	357.7701	358.12	357.03	357.46	1718963.0

> showing 50 of 24,329 rows — these rows as CSV

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