PREVIEW / etf_30min / 2023-05-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-01.parquet
  size:    679 KB
  rows:    27,405

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-05-01 04:00:00	SPY	ETF	416.15	416.15	415.67	415.74	214920.0
2023-05-01 04:30:00	SPY	ETF	415.72	415.79	415.58	415.7	8562.0
2023-05-01 05:00:00	SPY	ETF	415.81	416.14	415.79	416.05	8045.0
2023-05-01 05:30:00	SPY	ETF	416.06	416.06	415.89	416.0	67228.0
2023-05-01 06:00:00	SPY	ETF	415.99	416.04	415.83	415.84	13409.0
2023-05-01 06:30:00	SPY	ETF	415.86	415.95	415.62	415.9	43341.0
2023-05-01 07:00:00	SPY	ETF	415.9	415.949	415.63	415.75	60506.0
2023-05-01 07:30:00	SPY	ETF	415.74	415.82	415.4	415.42	100593.0
2023-05-01 08:00:00	SPY	ETF	415.91	416.34	415.3	415.48	96049.0
2023-05-01 08:30:00	SPY	ETF	415.48	415.82	415.27	415.73	190371.0
2023-05-01 09:00:00	SPY	ETF	415.69	415.93	415.2	415.44	242629.0
2023-05-01 09:30:00	SPY	ETF	415.47	416.7299	415.38	416.3899	5403667.0
2023-05-01 10:00:00	SPY	ETF	416.36	416.7808	415.77	415.9901	4381277.0
2023-05-01 10:30:00	SPY	ETF	416.0	417.07	415.82	416.9599	2988264.0
2023-05-01 11:00:00	SPY	ETF	416.96	417.14	415.57	415.86	3751669.0
2023-05-01 11:30:00	SPY	ETF	415.85	416.39	415.7096	416.3499	2580639.0
2023-05-01 12:00:00	SPY	ETF	416.33	416.9	416.295	416.805	2022536.0
2023-05-01 12:30:00	SPY	ETF	416.8	417.62	416.8	417.16	2809951.0
2023-05-01 13:00:00	SPY	ETF	417.19	417.33	416.78	416.832	1716457.0
2023-05-01 13:30:00	SPY	ETF	416.84	417.19	416.625	417.03	1943283.0
2023-05-01 14:00:00	SPY	ETF	417.03	417.13	416.39	416.555	2793732.0
2023-05-01 14:30:00	SPY	ETF	416.57	416.57	415.42	416.08	3914347.0
2023-05-01 15:00:00	SPY	ETF	416.08	416.22	415.64	415.795	3259706.0
2023-05-01 15:30:00	SPY	ETF	415.8	416.09	415.265	415.53	8821750.0
2023-05-01 16:00:00	SPY	ETF	415.53	416.2898	415.44	415.54	2552699.0
2023-05-01 16:30:00	SPY	ETF	415.53	415.54	414.93	415.05	501502.0
2023-05-01 17:00:00	SPY	ETF	414.97	415.13	414.97	415.05	107677.0
2023-05-01 17:30:00	SPY	ETF	415.1	415.15	414.96	415.01	43832.0
2023-05-01 18:00:00	SPY	ETF	415.0	415.01	414.78	415.01	28475.0
2023-05-01 18:30:00	SPY	ETF	415.07	415.1	414.92	415.04	11834.0
2023-05-01 19:00:00	SPY	ETF	415.0	415.13	415.0	415.0	15682.0
2023-05-01 19:30:00	SPY	ETF	415.0	415.05	414.96	415.0	15126.0
2023-05-01 04:00:00	QQQ	ETF	322.8	322.93	322.12	322.22	15378.0
2023-05-01 04:30:00	QQQ	ETF	322.21	322.46	322.05	322.38	13130.0
2023-05-01 05:00:00	QQQ	ETF	322.43	322.86	322.43	322.68	5388.0
2023-05-01 05:30:00	QQQ	ETF	322.77	322.77	322.45	322.5	2475.0
2023-05-01 06:00:00	QQQ	ETF	322.5	322.58	322.33	322.4	8240.0
2023-05-01 06:30:00	QQQ	ETF	322.45	322.45	322.17	322.34	67307.0
2023-05-01 07:00:00	QQQ	ETF	322.36	322.5	322.22	322.46	44702.0
2023-05-01 07:30:00	QQQ	ETF	322.4	322.47	322.1	322.22	81094.0
2023-05-01 08:00:00	QQQ	ETF	322.33	323.02	321.74	321.94	159211.0
2023-05-01 08:30:00	QQQ	ETF	321.85	322.29	321.78	322.18	101360.0
2023-05-01 09:00:00	QQQ	ETF	322.18	322.26	321.92	322.05	128711.0
2023-05-01 09:30:00	QQQ	ETF	322.09	322.77	321.75	322.35	3602022.0
2023-05-01 10:00:00	QQQ	ETF	322.34	322.51	321.61	321.8	3431827.0
2023-05-01 10:30:00	QQQ	ETF	321.79	322.72	321.5497	322.655	2648854.0
2023-05-01 11:00:00	QQQ	ETF	322.66	322.88	321.09	321.31	3041218.0
2023-05-01 11:30:00	QQQ	ETF	321.3	322.0198	321.19	322.0	1686793.0
2023-05-01 12:00:00	QQQ	ETF	322.01	322.61	321.95	322.55	1308174.0
2023-05-01 12:30:00	QQQ	ETF	322.56	323.31	322.56	323.21	2026436.0

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

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