PREVIEW / etf_30min / 2021-05-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-06.parquet
  size:    612 KB
  rows:    23,487

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
2021-05-06 04:00:00	SPY	ETF	416.4	416.68	416.2	416.68	5900.0
2021-05-06 04:30:00	SPY	ETF	416.42	416.42	415.92	416.03	6700.0
2021-05-06 05:00:00	SPY	ETF	416.08	416.35	415.59	415.85	12999.0
2021-05-06 05:30:00	SPY	ETF	415.75	415.97	415.38	415.97	1300.0
2021-05-06 06:00:00	SPY	ETF	415.98	416.4	415.97	416.27	7244.0
2021-05-06 06:30:00	SPY	ETF	416.25	416.5	415.89	415.9	16469.0
2021-05-06 07:00:00	SPY	ETF	415.85	416.28	415.75	416.06	97956.0
2021-05-06 07:30:00	SPY	ETF	416.03	416.05	415.71	415.95	56265.0
2021-05-06 08:00:00	SPY	ETF	415.9101	416.91	415.33	415.43	170729.0
2021-05-06 08:30:00	SPY	ETF	415.52	415.79	415.19	415.6	240103.0
2021-05-06 09:00:00	SPY	ETF	415.6	415.98	415.5	415.84	116841.0
2021-05-06 09:30:00	SPY	ETF	415.83	416.31	414.76	414.79	5392663.0
2021-05-06 10:00:00	SPY	ETF	414.79	414.91	413.675	414.31	5674324.0
2021-05-06 10:30:00	SPY	ETF	414.3	415.3515	414.19	415.135	3160737.0
2021-05-06 11:00:00	SPY	ETF	415.13	416.1	414.24	416.07	3781183.0
2021-05-06 11:30:00	SPY	ETF	416.08	417.58	415.96	416.895	6071483.0
2021-05-06 12:00:00	SPY	ETF	416.9	417.53	416.58	417.52	2407022.0
2021-05-06 12:30:00	SPY	ETF	417.525	417.57	416.9199	416.95	2579882.0
2021-05-06 13:00:00	SPY	ETF	416.94	417.24	416.41	416.7	2615438.0
2021-05-06 13:30:00	SPY	ETF	416.71	416.96	416.19	416.23	1866686.0
2021-05-06 14:00:00	SPY	ETF	416.23	416.78	415.74	415.93	3902903.0
2021-05-06 14:30:00	SPY	ETF	415.94	416.59	415.66	416.17	3668169.0
2021-05-06 15:00:00	SPY	ETF	416.17	417.21	416.02	417.03	3776812.0
2021-05-06 15:30:00	SPY	ETF	417.03	419.21	416.95	419.08	13698937.0
2021-05-06 16:00:00	SPY	ETF	419.08	419.28	418.5459	418.99	3315593.0
2021-05-06 16:30:00	SPY	ETF	419.0	419.31	418.91	419.24	207588.0
2021-05-06 17:00:00	SPY	ETF	419.26	419.26	419.1	419.18	67900.0
2021-05-06 17:30:00	SPY	ETF	419.18	419.26	419.1	419.26	31434.0
2021-05-06 18:00:00	SPY	ETF	419.29	419.39	419.08	419.21	91350.0
2021-05-06 18:30:00	SPY	ETF	419.07	419.21	419.07	419.15	125244.0
2021-05-06 19:00:00	SPY	ETF	419.15	419.25	419.02	419.07	32228.0
2021-05-06 19:30:00	SPY	ETF	419.03	419.13	418.98	419.12	32246.0
2021-05-06 04:00:00	QQQ	ETF	330.04	330.5	329.92	330.45	29011.0
2021-05-06 04:30:00	QQQ	ETF	330.41	330.41	329.49	329.74	22432.0
2021-05-06 05:00:00	QQQ	ETF	329.94	330.27	329.31	329.57	28748.0
2021-05-06 05:30:00	QQQ	ETF	329.47	329.53	328.91	329.4	22042.0
2021-05-06 06:00:00	QQQ	ETF	329.47	330.07	329.4	329.89	26754.0
2021-05-06 06:30:00	QQQ	ETF	329.93	330.28	329.42	329.44	83655.0
2021-05-06 07:00:00	QQQ	ETF	329.41	329.75	329.12	329.58	170149.0
2021-05-06 07:30:00	QQQ	ETF	329.5	329.51	329.22	329.24	52751.0
2021-05-06 08:00:00	QQQ	ETF	329.33	330.47	328.37	328.82	140287.0
2021-05-06 08:30:00	QQQ	ETF	328.8	328.85	328.26	328.6	168792.0
2021-05-06 09:00:00	QQQ	ETF	328.63	328.9	328.38	328.74	151212.0
2021-05-06 09:30:00	QQQ	ETF	328.76	329.37	327.3	327.41	6474884.0
2021-05-06 10:00:00	QQQ	ETF	327.39	327.89	326.45	327.18	4169731.0
2021-05-06 10:30:00	QQQ	ETF	327.16	328.855	327.01	328.31	3202178.0
2021-05-06 11:00:00	QQQ	ETF	328.31	329.02	326.91	328.99	3015108.0
2021-05-06 11:30:00	QQQ	ETF	328.99	330.71	328.845	330.26	3171946.0
2021-05-06 12:00:00	QQQ	ETF	330.27	331.14	329.879	331.1272	1376052.0
2021-05-06 12:30:00	QQQ	ETF	331.1202	331.36	330.54	330.67	1805315.0

> showing 50 of 23,487 rows — these rows as CSV

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