PREVIEW / etf_30min / 2023-04-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-28.parquet
  size:    675 KB
  rows:    27,110

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-04-28 04:00:00	SPY	ETF	411.51	411.51	410.78	410.78	35315.0
2023-04-28 04:30:00	SPY	ETF	410.75	410.85	410.46	410.58	65668.0
2023-04-28 05:00:00	SPY	ETF	410.53	411.1	410.22	411.0	369891.0
2023-04-28 05:30:00	SPY	ETF	410.94	411.1	410.9	411.02	10541.0
2023-04-28 06:00:00	SPY	ETF	411.0	411.17	410.81	411.11	15833.0
2023-04-28 06:30:00	SPY	ETF	411.04	411.04	410.75	410.75	19058.0
2023-04-28 07:00:00	SPY	ETF	410.77	411.25	410.73	411.24	159524.0
2023-04-28 07:30:00	SPY	ETF	411.21	411.29	410.8	410.82	404817.0
2023-04-28 08:00:00	SPY	ETF	411.0	413.0	410.3204	411.15	579219.0
2023-04-28 08:30:00	SPY	ETF	411.18	411.6	410.57	411.33	495594.0
2023-04-28 09:00:00	SPY	ETF	411.34	411.73	411.31	411.49	348093.0
2023-04-28 09:30:00	SPY	ETF	411.49	412.77	411.43	412.54	6117590.0
2023-04-28 10:00:00	SPY	ETF	412.49	414.81	412.34	414.7	8624555.0
2023-04-28 10:30:00	SPY	ETF	414.695	414.8	412.88	413.249	6892291.0
2023-04-28 11:00:00	SPY	ETF	413.23	413.86	412.31	413.7499	4159029.0
2023-04-28 11:30:00	SPY	ETF	413.745	414.87	413.745	414.7489	2764315.0
2023-04-28 12:00:00	SPY	ETF	414.745	415.1091	414.365	414.945	3042369.0
2023-04-28 12:30:00	SPY	ETF	414.95	415.54	414.56	415.46	2382742.0
2023-04-28 13:00:00	SPY	ETF	415.45	415.52	414.93	415.4499	1966262.0
2023-04-28 13:30:00	SPY	ETF	415.445	415.545	414.55	414.9475	3051873.0
2023-04-28 14:00:00	SPY	ETF	414.955	415.48	414.59	414.78	3407038.0
2023-04-28 14:30:00	SPY	ETF	414.79	414.9	414.11	414.8	3609354.0
2023-04-28 15:00:00	SPY	ETF	414.8	415.58	414.7	414.92	4032460.0
2023-04-28 15:30:00	SPY	ETF	414.915	415.94	414.64	415.93	11577999.0
2023-04-28 16:00:00	SPY	ETF	415.93	416.31	414.4723	416.0	5099081.0
2023-04-28 16:30:00	SPY	ETF	416.0	416.1	415.89	416.0	169094.0
2023-04-28 17:00:00	SPY	ETF	416.05	416.08	415.75	415.75	102487.0
2023-04-28 17:30:00	SPY	ETF	415.75	415.93	415.6	415.6	1011402.0
2023-04-28 18:00:00	SPY	ETF	415.6	416.0	415.51	415.98	47366.0
2023-04-28 18:30:00	SPY	ETF	415.98	416.24	415.94	416.13	30044.0
2023-04-28 19:00:00	SPY	ETF	416.1	416.1	416.09	416.09	2562.0
2023-04-28 19:30:00	SPY	ETF	416.09	416.18	416.04	416.17	21897.0
2023-04-28 04:00:00	QQQ	ETF	319.55	319.85	319.28	319.3	78820.0
2023-04-28 04:30:00	QQQ	ETF	319.27	319.43	319.19	319.38	28579.0
2023-04-28 05:00:00	QQQ	ETF	319.3	319.59	319.02	319.5	40527.0
2023-04-28 05:30:00	QQQ	ETF	319.37	319.5	319.22	319.36	17294.0
2023-04-28 06:00:00	QQQ	ETF	319.32	319.56	319.19	319.51	24070.0
2023-04-28 06:30:00	QQQ	ETF	319.42	319.6	319.37	319.41	34020.0
2023-04-28 07:00:00	QQQ	ETF	319.46	319.74	319.4	319.71	83294.0
2023-04-28 07:30:00	QQQ	ETF	319.72	319.83	319.31	319.32	250413.0
2023-04-28 08:00:00	QQQ	ETF	319.5687	320.59	319.03	319.5	362731.0
2023-04-28 08:30:00	QQQ	ETF	319.6	320.2	318.92	319.85	473781.0
2023-04-28 09:00:00	QQQ	ETF	319.86	320.38	319.79	320.12	545741.0
2023-04-28 09:30:00	QQQ	ETF	320.11	320.705	318.96	319.85	6720861.0
2023-04-28 10:00:00	QQQ	ETF	319.83	321.85	319.38	321.8399	5469187.0
2023-04-28 10:30:00	QQQ	ETF	321.83	321.87	319.46	319.828	4806122.0
2023-04-28 11:00:00	QQQ	ETF	319.84	320.14	319.22	319.98	3521482.0
2023-04-28 11:30:00	QQQ	ETF	319.98	321.03	319.97	320.94	2310090.0
2023-04-28 12:00:00	QQQ	ETF	320.93	321.38	320.485	320.99	2043946.0
2023-04-28 12:30:00	QQQ	ETF	320.99	321.72	320.5	321.67	1736027.0

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

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