PREVIEW / etf_30min / 2022-05-03

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-03.parquet
  size:    664 KB
  rows:    26,434

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-05-03 04:00:00	SPY	ETF	415.64	416.64	415.39	415.39	43919.0
2022-05-03 04:30:00	SPY	ETF	415.22	415.25	414.73	414.86	19125.0
2022-05-03 05:00:00	SPY	ETF	414.48	414.82	414.21	414.39	19454.0
2022-05-03 05:30:00	SPY	ETF	414.49	415.0	414.49	414.7	27452.0
2022-05-03 06:00:00	SPY	ETF	414.78	414.89	413.34	413.48	41265.0
2022-05-03 06:30:00	SPY	ETF	413.46	413.46	412.42	412.84	36556.0
2022-05-03 07:00:00	SPY	ETF	412.84	413.4	412.5	413.32	111888.0
2022-05-03 07:30:00	SPY	ETF	413.35	414.08	413.15	413.89	172234.0
2022-05-03 08:00:00	SPY	ETF	412.8701	416.37	412.55	414.63	260659.0
2022-05-03 08:30:00	SPY	ETF	414.6	415.59	414.31	415.4	315788.0
2022-05-03 09:00:00	SPY	ETF	415.39	415.45	414.4	415.01	249219.0
2022-05-03 09:30:00	SPY	ETF	415.01	415.7117	413.36	415.42	10912660.0
2022-05-03 10:00:00	SPY	ETF	415.44	416.27	413.78	415.72	8100059.0
2022-05-03 10:30:00	SPY	ETF	415.75	416.7	413.9	415.25	6176847.0
2022-05-03 11:00:00	SPY	ETF	415.23	418.56	414.72	417.95	5819198.0
2022-05-03 11:30:00	SPY	ETF	417.96	418.93	417.26	417.9	3867086.0
2022-05-03 12:00:00	SPY	ETF	417.89	418.76	415.9525	416.65	5123160.0
2022-05-03 12:30:00	SPY	ETF	416.63	417.48	416.01	416.98	3294659.0
2022-05-03 13:00:00	SPY	ETF	416.99	418.71	416.905	417.67	3263664.0
2022-05-03 13:30:00	SPY	ETF	417.68	418.63	417.28	417.55	3088252.0
2022-05-03 14:00:00	SPY	ETF	417.55	417.58	414.87	414.99	4757162.0
2022-05-03 14:30:00	SPY	ETF	415.0	417.49	414.115	417.3167	5637625.0
2022-05-03 15:00:00	SPY	ETF	417.31	417.98	415.97	416.65	4727792.0
2022-05-03 15:30:00	SPY	ETF	416.65	417.34	414.79	416.42	11792322.0
2022-05-03 16:00:00	SPY	ETF	416.42	417.6	416.21	416.52	5936865.0
2022-05-03 16:30:00	SPY	ETF	416.6	416.84	416.0	416.7404	230858.0
2022-05-03 17:00:00	SPY	ETF	416.67	416.97	416.67	416.89	98769.0
2022-05-03 17:30:00	SPY	ETF	416.9	417.01	416.75	416.87	77222.0
2022-05-03 18:00:00	SPY	ETF	416.73	417.12	416.43	417.0199	76145.0
2022-05-03 18:30:00	SPY	ETF	416.99	417.0896	416.78	416.81	19031.0
2022-05-03 19:00:00	SPY	ETF	416.71	416.86	416.68	416.86	31579.0
2022-05-03 19:30:00	SPY	ETF	416.78	417.29	416.78	416.92	17453.0
2022-05-03 04:00:00	QQQ	ETF	318.39	319.83	318.39	318.86	73257.0
2022-05-03 04:30:00	QQQ	ETF	318.93	318.95	318.19	318.63	15927.0
2022-05-03 05:00:00	QQQ	ETF	318.5	318.64	318.09	318.28	55519.0
2022-05-03 05:30:00	QQQ	ETF	318.18	318.9	318.18	318.54	29783.0
2022-05-03 06:00:00	QQQ	ETF	318.58	318.81	317.38	317.49	38308.0
2022-05-03 06:30:00	QQQ	ETF	317.45	317.53	316.83	317.19	53175.0
2022-05-03 07:00:00	QQQ	ETF	317.23	317.65	316.89	317.62	124406.0
2022-05-03 07:30:00	QQQ	ETF	317.59	318.22	317.38	318.17	87354.0
2022-05-03 08:00:00	QQQ	ETF	316.99	320.05	316.8596	318.74	297154.0
2022-05-03 08:30:00	QQQ	ETF	318.73	319.62	318.34	319.35	249768.0
2022-05-03 09:00:00	QQQ	ETF	319.33	319.4	318.29	318.51	246294.0
2022-05-03 09:30:00	QQQ	ETF	318.5	319.48	315.98	319.44	10398888.0
2022-05-03 10:00:00	QQQ	ETF	319.41	320.43	317.0	318.43	6383313.0
2022-05-03 10:30:00	QQQ	ETF	318.5	319.37	316.16	317.44	4813749.0
2022-05-03 11:00:00	QQQ	ETF	317.37	320.24	316.75	319.4199	4705772.0
2022-05-03 11:30:00	QQQ	ETF	319.45	320.14	318.51	319.2935	2937980.0
2022-05-03 12:00:00	QQQ	ETF	319.26	320.21	317.36	318.0887	3471708.0
2022-05-03 12:30:00	QQQ	ETF	318.06	319.19	317.56	318.74	2517177.0

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

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