PREVIEW / etf_30min / 2023-03-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-06.parquet
  size:    682 KB
  rows:    27,277

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
2023-03-06 04:00:00	SPY	ETF	404.58	404.71	404.15	404.15	21511.0
2023-03-06 04:30:00	SPY	ETF	404.08	404.26	404.0	404.1	9352.0
2023-03-06 05:00:00	SPY	ETF	404.13	404.26	404.0	404.09	7311.0
2023-03-06 05:30:00	SPY	ETF	404.05	404.41	403.89	404.38	8099.0
2023-03-06 06:00:00	SPY	ETF	404.37	404.57	404.2	404.27	14267.0
2023-03-06 06:30:00	SPY	ETF	404.19	404.27	403.62	403.78	56668.0
2023-03-06 07:00:00	SPY	ETF	403.73	404.01	403.68	403.98	111332.0
2023-03-06 07:30:00	SPY	ETF	403.97	404.39	403.89	404.39	166938.0
2023-03-06 08:00:00	SPY	ETF	403.72	405.03	403.69	405.0	311500.0
2023-03-06 08:30:00	SPY	ETF	404.94	405.63	404.87	405.13	305324.0
2023-03-06 09:00:00	SPY	ETF	405.14	405.27	404.94	405.05	254947.0
2023-03-06 09:30:00	SPY	ETF	405.04	405.85	404.76	405.76	6718413.0
2023-03-06 10:00:00	SPY	ETF	405.77	407.03	405.24	406.63	5684309.0
2023-03-06 10:30:00	SPY	ETF	406.64	407.37	406.56	406.6499	4598201.0
2023-03-06 11:00:00	SPY	ETF	406.65	407.45	406.39	406.5	3702351.0
2023-03-06 11:30:00	SPY	ETF	406.495	406.9	406.23	406.7899	2443811.0
2023-03-06 12:00:00	SPY	ETF	406.79	407.38	406.64	406.81	2331113.0
2023-03-06 12:30:00	SPY	ETF	406.815	406.82	405.57	405.85	3589578.0
2023-03-06 13:00:00	SPY	ETF	405.85	405.92	405.29	405.6078	2572880.0
2023-03-06 13:30:00	SPY	ETF	405.62	405.68	404.6031	404.855	3641597.0
2023-03-06 14:00:00	SPY	ETF	404.88	405.36	404.63	404.95	2874170.0
2023-03-06 14:30:00	SPY	ETF	404.95	405.2	404.57	404.72	3157407.0
2023-03-06 15:00:00	SPY	ETF	404.7218	405.02	404.09	404.095	4680429.0
2023-03-06 15:30:00	SPY	ETF	404.1	404.8	404.03	404.46	7790266.0
2023-03-06 16:00:00	SPY	ETF	404.46	404.73	404.43	404.71	2378352.0
2023-03-06 16:30:00	SPY	ETF	404.7	404.74	404.62	404.62	134183.0
2023-03-06 17:00:00	SPY	ETF	404.61	404.63	404.45	404.55	23090.0
2023-03-06 17:30:00	SPY	ETF	404.58	404.6	404.52	404.55	14121.0
2023-03-06 18:00:00	SPY	ETF	404.56	404.68	404.4	404.68	35413.0
2023-03-06 18:30:00	SPY	ETF	404.69	404.76	404.51	404.69	33333.0
2023-03-06 19:00:00	SPY	ETF	404.69	404.9	404.61	404.85	19587.0
2023-03-06 19:30:00	SPY	ETF	404.85	404.9	404.58	404.75	23994.0
2023-03-06 04:00:00	QQQ	ETF	300.2	300.42	299.92	299.92	24538.0
2023-03-06 04:30:00	QQQ	ETF	299.8	299.95	299.56	299.65	10570.0
2023-03-06 05:00:00	QQQ	ETF	299.65	299.87	299.56	299.81	8884.0
2023-03-06 05:30:00	QQQ	ETF	299.8	300.16	299.55	300.13	13726.0
2023-03-06 06:00:00	QQQ	ETF	300.09	300.4	299.94	300.03	17953.0
2023-03-06 06:30:00	QQQ	ETF	299.97	299.97	299.38	299.49	66306.0
2023-03-06 07:00:00	QQQ	ETF	299.5	299.81	299.48	299.8	52322.0
2023-03-06 07:30:00	QQQ	ETF	299.8	300.17	299.7	300.17	115557.0
2023-03-06 08:00:00	QQQ	ETF	299.51	300.96	299.51	300.89	235526.0
2023-03-06 08:30:00	QQQ	ETF	300.89	301.45	300.76	301.09	320365.0
2023-03-06 09:00:00	QQQ	ETF	301.06	301.27	300.78	300.98	407016.0
2023-03-06 09:30:00	QQQ	ETF	300.94	301.81	300.63	301.4732	5144084.0
2023-03-06 10:00:00	QQQ	ETF	301.48	302.915	300.91	302.7201	3735715.0
2023-03-06 10:30:00	QQQ	ETF	302.76	303.69	302.59	303.23	3525404.0
2023-03-06 11:00:00	QQQ	ETF	303.23	304.0	302.98	303.105	3099452.0
2023-03-06 11:30:00	QQQ	ETF	303.1008	303.44	302.8373	303.335	2226749.0
2023-03-06 12:00:00	QQQ	ETF	303.34	303.54	302.89	303.035	1594027.0
2023-03-06 12:30:00	QQQ	ETF	303.04	303.04	301.51	301.83	3062052.0

> showing 50 of 27,277 rows — these rows as CSV

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