PREVIEW / etf_30min / 2021-04-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-19.parquet
  size:    622 KB
  rows:    23,838

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-04-19 04:00:00	SPY	ETF	416.87	417.06	416.71	416.81	17501.0
2021-04-19 04:30:00	SPY	ETF	416.82	416.91	416.77	416.77	5350.0
2021-04-19 05:00:00	SPY	ETF	416.77	416.77	416.56	416.56	7407.0
2021-04-19 05:30:00	SPY	ETF	416.51	416.56	416.28	416.5	9322.0
2021-04-19 06:00:00	SPY	ETF	416.48	416.65	416.45	416.65	50600.0
2021-04-19 06:30:00	SPY	ETF	416.64	416.65	415.95	416.29	125695.0
2021-04-19 07:00:00	SPY	ETF	416.32	416.46	416.1	416.14	140716.0
2021-04-19 07:30:00	SPY	ETF	416.15	416.29	416.08	416.18	66349.0
2021-04-19 08:00:00	SPY	ETF	416.2201	416.45	416.01	416.18	113951.0
2021-04-19 08:30:00	SPY	ETF	416.18	416.48	416.1	416.39	135874.0
2021-04-19 09:00:00	SPY	ETF	416.43	416.55	415.99	416.21	212072.0
2021-04-19 09:30:00	SPY	ETF	416.26	416.74	416.21	416.62	4165165.0
2021-04-19 10:00:00	SPY	ETF	416.62	416.67	415.07	415.785	6055027.0
2021-04-19 10:30:00	SPY	ETF	415.79	416.065	414.38	415.3518	5486288.0
2021-04-19 11:00:00	SPY	ETF	415.345	415.71	414.88	415.64	2835322.0
2021-04-19 11:30:00	SPY	ETF	415.64	415.67	414.24	414.84	3948614.0
2021-04-19 12:00:00	SPY	ETF	414.82	415.26	414.23	414.53	4346931.0
2021-04-19 12:30:00	SPY	ETF	414.54	414.625	413.79	414.205	3557627.0
2021-04-19 13:00:00	SPY	ETF	414.205	414.94	414.04	414.63	2682521.0
2021-04-19 13:30:00	SPY	ETF	414.61	415.09	414.425	414.67	2144827.0
2021-04-19 14:00:00	SPY	ETF	414.67	415.09	414.38	415.01	2219578.0
2021-04-19 14:30:00	SPY	ETF	415.005	415.12	414.37	415.077	2576685.0
2021-04-19 15:00:00	SPY	ETF	415.075	415.195	414.22	414.325	4133293.0
2021-04-19 15:30:00	SPY	ETF	414.32	415.34	414.14	415.26	9627505.0
2021-04-19 16:00:00	SPY	ETF	415.26	415.42	415.074	415.29	3208186.0
2021-04-19 16:30:00	SPY	ETF	415.29	415.39	415.13	415.21	167013.0
2021-04-19 17:00:00	SPY	ETF	415.21	415.25	415.17	415.2	17522.0
2021-04-19 17:30:00	SPY	ETF	415.23	415.26	415.16	415.16	41485.0
2021-04-19 18:00:00	SPY	ETF	415.16	415.37	415.16	415.37	56672.0
2021-04-19 18:30:00	SPY	ETF	415.41	415.55	415.41	415.49	27442.0
2021-04-19 19:00:00	SPY	ETF	415.5	415.51	415.39	415.42	26901.0
2021-04-19 19:30:00	SPY	ETF	415.41	415.78	415.27	415.72	125752.0
2021-04-19 04:00:00	QQQ	ETF	342.31	342.34	341.79	341.87	35713.0
2021-04-19 04:30:00	QQQ	ETF	341.9	342.07	341.85	342.03	12639.0
2021-04-19 05:00:00	QQQ	ETF	342.03	342.08	341.85	341.93	4126.0
2021-04-19 05:30:00	QQQ	ETF	341.85	341.94	341.66	341.75	6660.0
2021-04-19 06:00:00	QQQ	ETF	341.77	341.8	341.61	341.67	8341.0
2021-04-19 06:30:00	QQQ	ETF	341.67	341.73	340.71	340.96	47081.0
2021-04-19 07:00:00	QQQ	ETF	341.0	341.21	340.82	340.9	55893.0
2021-04-19 07:30:00	QQQ	ETF	340.87	341.11	340.8	340.84	56270.0
2021-04-19 08:00:00	QQQ	ETF	340.7904	342.38	340.18	340.52	132256.0
2021-04-19 08:30:00	QQQ	ETF	340.53	340.63	340.25	340.44	67907.0
2021-04-19 09:00:00	QQQ	ETF	340.43	340.64	339.96	340.42	195606.0
2021-04-19 09:30:00	QQQ	ETF	340.4	341.58	340.06	341.12	3110644.0
2021-04-19 10:00:00	QQQ	ETF	341.12	341.41	338.571	339.52	3888953.0
2021-04-19 10:30:00	QQQ	ETF	339.53	339.871	337.87	339.43	3377686.0
2021-04-19 11:00:00	QQQ	ETF	339.41	339.985	338.97	339.39	1984691.0
2021-04-19 11:30:00	QQQ	ETF	339.38	339.44	337.725	338.32	2544021.0
2021-04-19 12:00:00	QQQ	ETF	338.29	338.7772	337.4303	337.7628	2282377.0
2021-04-19 12:30:00	QQQ	ETF	337.76	337.89	336.9016	337.58	1836503.0

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

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