PREVIEW / etf_30min / 2022-05-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-04.parquet
  size:    677 KB
  rows:    27,106

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-04 04:00:00	SPY	ETF	417.36	417.62	417.11	417.62	11404.0
2022-05-04 04:30:00	SPY	ETF	417.61	417.61	417.28	417.58	4000.0
2022-05-04 05:00:00	SPY	ETF	417.28	417.28	416.93	417.21	12500.0
2022-05-04 05:30:00	SPY	ETF	417.39	418.0	417.35	418.0	6896.0
2022-05-04 06:00:00	SPY	ETF	418.15	418.19	417.81	417.81	12830.0
2022-05-04 06:30:00	SPY	ETF	417.92	418.13	417.77	417.93	29331.0
2022-05-04 07:00:00	SPY	ETF	417.88	418.45	417.66	418.32	117363.0
2022-05-04 07:30:00	SPY	ETF	418.35	418.43	417.75	417.85	122589.0
2022-05-04 08:00:00	SPY	ETF	417.9	418.42	416.75	417.71	122828.0
2022-05-04 08:30:00	SPY	ETF	417.82	417.86	417.14	417.15	196537.0
2022-05-04 09:00:00	SPY	ETF	417.1	417.47	416.94	417.07	191916.0
2022-05-04 09:30:00	SPY	ETF	417.07	417.42	416.02	416.0319	6730491.0
2022-05-04 10:00:00	SPY	ETF	416.045	416.16	414.45	415.33	5627329.0
2022-05-04 10:30:00	SPY	ETF	415.33	415.68	414.25	415.06	3681508.0
2022-05-04 11:00:00	SPY	ETF	415.07	415.25	414.03	414.34	2853115.0
2022-05-04 11:30:00	SPY	ETF	414.34	415.75	413.7099	415.225	3191994.0
2022-05-04 12:00:00	SPY	ETF	415.22	417.15	414.91	416.98	3531141.0
2022-05-04 12:30:00	SPY	ETF	416.98	418.09	416.87	418.045	3554642.0
2022-05-04 13:00:00	SPY	ETF	418.04	418.47	416.9	417.35	3783848.0
2022-05-04 13:30:00	SPY	ETF	417.33	418.92	416.9516	418.205	3022249.0
2022-05-04 14:00:00	SPY	ETF	418.16	420.15	415.7	418.86	11758915.0
2022-05-04 14:30:00	SPY	ETF	418.85	424.25	414.12	423.7	20079152.0
2022-05-04 15:00:00	SPY	ETF	423.71	427.09	423.08	427.01	12719127.0
2022-05-04 15:30:00	SPY	ETF	427.03	429.66	426.96	428.99	24681345.0
2022-05-04 16:00:00	SPY	ETF	428.98	429.06	428.08	428.08	4572348.0
2022-05-04 16:30:00	SPY	ETF	428.1	429.06	427.88	427.95	470965.0
2022-05-04 17:00:00	SPY	ETF	427.94	428.4	427.92	428.37	290860.0
2022-05-04 17:30:00	SPY	ETF	428.38	428.43	428.25	428.31	63448.0
2022-05-04 18:00:00	SPY	ETF	428.32	428.93	428.2	428.71	203878.0
2022-05-04 18:30:00	SPY	ETF	428.75	428.75	427.97	428.1	103370.0
2022-05-04 19:00:00	SPY	ETF	428.15	428.36	428.1	428.16	31485.0
2022-05-04 19:30:00	SPY	ETF	428.16	428.2	427.9	428.16	70111.0
2022-05-04 04:00:00	QQQ	ETF	319.58	319.93	319.42	319.61	20581.0
2022-05-04 04:30:00	QQQ	ETF	319.71	319.71	319.38	319.62	5848.0
2022-05-04 05:00:00	QQQ	ETF	319.39	319.44	318.96	319.39	9745.0
2022-05-04 05:30:00	QQQ	ETF	319.43	319.79	319.3	319.79	4372.0
2022-05-04 06:00:00	QQQ	ETF	319.83	319.91	319.59	319.59	16949.0
2022-05-04 06:30:00	QQQ	ETF	319.73	320.12	319.64	319.85	58706.0
2022-05-04 07:00:00	QQQ	ETF	319.83	320.41	319.64	320.37	52878.0
2022-05-04 07:30:00	QQQ	ETF	320.39	320.43	319.89	319.91	58683.0
2022-05-04 08:00:00	QQQ	ETF	320.35	320.42	319.25	319.76	132180.0
2022-05-04 08:30:00	QQQ	ETF	319.77	319.8	319.26	319.4	96157.0
2022-05-04 09:00:00	QQQ	ETF	319.22	319.58	319.04	319.32	186127.0
2022-05-04 09:30:00	QQQ	ETF	319.31	319.47	317.11	317.145	5730163.0
2022-05-04 10:00:00	QQQ	ETF	317.16	317.37	315.06	315.81	5054280.0
2022-05-04 10:30:00	QQQ	ETF	315.85	316.3	314.76	315.1	3831424.0
2022-05-04 11:00:00	QQQ	ETF	315.11	315.26	314.0	314.5135	3025552.0
2022-05-04 11:30:00	QQQ	ETF	314.52	316.2	313.891	315.785	3527239.0
2022-05-04 12:00:00	QQQ	ETF	315.78	318.24	315.5	318.15	3251464.0
2022-05-04 12:30:00	QQQ	ETF	318.14	319.2394	317.78	319.21	3295500.0

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

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