PREVIEW / etf_30min / 2022-08-03

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-03.parquet
  size:    658 KB
  rows:    26,101

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
2022-08-03 04:00:00	SPY	ETF	408.64	408.86	408.09	408.83	9899.0
2022-08-03 04:30:00	SPY	ETF	409.01	409.23	408.88	408.95	13684.0
2022-08-03 05:00:00	SPY	ETF	409.2	410.02	409.2	409.9	12849.0
2022-08-03 05:30:00	SPY	ETF	409.92	410.13	409.61	409.71	19448.0
2022-08-03 06:00:00	SPY	ETF	409.67	409.93	409.5	409.5	14719.0
2022-08-03 06:30:00	SPY	ETF	409.57	409.66	409.4	409.66	32827.0
2022-08-03 07:00:00	SPY	ETF	409.66	410.27	409.58	410.27	30232.0
2022-08-03 07:30:00	SPY	ETF	410.25	410.27	409.64	410.03	43198.0
2022-08-03 08:00:00	SPY	ETF	409.67	410.8	408.4896	410.55	229713.0
2022-08-03 08:30:00	SPY	ETF	410.54	411.0	410.48	410.67	109301.0
2022-08-03 09:00:00	SPY	ETF	410.71	410.72	410.3	410.34	107105.0
2022-08-03 09:30:00	SPY	ETF	410.32	411.725	410.0	411.5288	4820236.0
2022-08-03 10:00:00	SPY	ETF	411.48	412.45	410.73	411.67	4262452.0
2022-08-03 10:30:00	SPY	ETF	411.66	411.9	410.18	411.58	2884938.0
2022-08-03 11:00:00	SPY	ETF	411.59	412.76	411.41	412.46	2810052.0
2022-08-03 11:30:00	SPY	ETF	412.45	413.4697	412.26	413.36	3590717.0
2022-08-03 12:00:00	SPY	ETF	413.3799	413.52	412.6701	413.2099	2061496.0
2022-08-03 12:30:00	SPY	ETF	413.2	414.64	413.16	414.33	2632999.0
2022-08-03 13:00:00	SPY	ETF	414.32	414.77	413.95	414.6	1868442.0
2022-08-03 13:30:00	SPY	ETF	414.6001	414.81	414.12	414.555	1858168.0
2022-08-03 14:00:00	SPY	ETF	414.56	415.22	414.24	414.9199	2474170.0
2022-08-03 14:30:00	SPY	ETF	414.93	415.13	414.36	414.815	2230090.0
2022-08-03 15:00:00	SPY	ETF	414.81	415.3425	414.58	414.83	2490124.0
2022-08-03 15:30:00	SPY	ETF	414.84	415.68	414.19	414.41	11092474.0
2022-08-03 16:00:00	SPY	ETF	414.41	414.45	413.75	413.86	3154664.0
2022-08-03 16:30:00	SPY	ETF	413.9	414.45	413.88	413.96	173240.0
2022-08-03 17:00:00	SPY	ETF	414.05	414.12	413.89	414.08	79427.0
2022-08-03 17:30:00	SPY	ETF	414.08	414.09	413.89	414.04	22647.0
2022-08-03 18:00:00	SPY	ETF	414.0	414.02	413.7	413.98	37035.0
2022-08-03 18:30:00	SPY	ETF	414.02	414.06	413.72	414.05	26401.0
2022-08-03 19:00:00	SPY	ETF	414.0	414.03	413.86	413.95	6409.0
2022-08-03 19:30:00	SPY	ETF	413.91	413.95	413.76	413.76	47997.0
2022-08-03 04:00:00	QQQ	ETF	313.99	314.45	313.66	314.45	25401.0
2022-08-03 04:30:00	QQQ	ETF	314.5	314.82	314.43	314.59	24660.0
2022-08-03 05:00:00	QQQ	ETF	314.49	315.93	314.48	315.79	29437.0
2022-08-03 05:30:00	QQQ	ETF	315.81	316.06	315.5	315.58	38829.0
2022-08-03 06:00:00	QQQ	ETF	315.52	315.63	315.2	315.34	68298.0
2022-08-03 06:30:00	QQQ	ETF	315.32	315.4	315.15	315.32	32781.0
2022-08-03 07:00:00	QQQ	ETF	315.38	316.12	315.26	316.09	67039.0
2022-08-03 07:30:00	QQQ	ETF	316.04	316.09	315.41	315.83	93985.0
2022-08-03 08:00:00	QQQ	ETF	315.6	316.59	313.6796	316.16	354837.0
2022-08-03 08:30:00	QQQ	ETF	316.16	316.61	316.13	316.22	180001.0
2022-08-03 09:00:00	QQQ	ETF	316.281	316.52	315.96	316.05	208572.0
2022-08-03 09:30:00	QQQ	ETF	316.05	319.32	315.99	319.069	5795706.0
2022-08-03 10:00:00	QQQ	ETF	319.03	320.42	318.27	319.3538	5084980.0
2022-08-03 10:30:00	QQQ	ETF	319.35	319.72	317.695	319.63	3531423.0
2022-08-03 11:00:00	QQQ	ETF	319.6334	320.86	319.38	320.61	2911249.0
2022-08-03 11:30:00	QQQ	ETF	320.61	321.63	320.31	321.58	2603390.0
2022-08-03 12:00:00	QQQ	ETF	321.56	321.67	320.7416	321.27	1985309.0
2022-08-03 12:30:00	QQQ	ETF	321.2701	322.9199	321.24	322.47	2295153.0

> showing 50 of 26,101 rows — these rows as CSV

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