PREVIEW / etf_30min / 2020-06-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-18.parquet
  size:    527 KB
  rows:    19,716

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
2020-06-18 04:00:00	SPY	ETF	311.56	312.2	311.15	311.57	45512.0
2020-06-18 04:30:00	SPY	ETF	311.51	313.21	311.41	312.9	56416.0
2020-06-18 05:00:00	SPY	ETF	312.72	312.91	312.16	312.56	48312.0
2020-06-18 05:30:00	SPY	ETF	312.56	313.29	311.96	312.26	37024.0
2020-06-18 06:00:00	SPY	ETF	312.17	312.17	311.29	312.07	31829.0
2020-06-18 06:30:00	SPY	ETF	311.88	311.99	311.51	311.73	21976.0
2020-06-18 07:00:00	SPY	ETF	311.68	311.94	310.38	310.78	263480.0
2020-06-18 07:30:00	SPY	ETF	310.78	310.9	309.47	309.56	333654.0
2020-06-18 08:00:00	SPY	ETF	310.7801	311.94	308.8	310.42	895863.0
2020-06-18 08:30:00	SPY	ETF	310.15	310.8	309.45	310.19	587417.0
2020-06-18 09:00:00	SPY	ETF	310.2	310.39	309.48	309.99	413666.0
2020-06-18 09:30:00	SPY	ETF	310.005	311.55	309.51	310.78	7715135.0
2020-06-18 10:00:00	SPY	ETF	310.76	311.95	310.75	311.15	4527551.0
2020-06-18 10:30:00	SPY	ETF	311.15	312.3	310.22	312.21	6106658.0
2020-06-18 11:00:00	SPY	ETF	312.2	312.3	311.56	311.73	3045109.0
2020-06-18 11:30:00	SPY	ETF	311.73	312.065	310.75	310.9199	3486648.0
2020-06-18 12:00:00	SPY	ETF	310.9	311.58	310.44	311.4	4061460.0
2020-06-18 12:30:00	SPY	ETF	311.41	311.51	310.81	311.39	2370618.0
2020-06-18 13:00:00	SPY	ETF	311.38	311.7	311.16	311.56	1754245.0
2020-06-18 13:30:00	SPY	ETF	311.56	311.99	311.49	311.845	1466019.0
2020-06-18 14:00:00	SPY	ETF	311.85	311.929	310.66	311.21	4893794.0
2020-06-18 14:30:00	SPY	ETF	311.215	311.74	310.47	310.53	4838516.0
2020-06-18 15:00:00	SPY	ETF	310.52	310.84	310.06	310.7743	7314849.0
2020-06-18 15:30:00	SPY	ETF	310.785	312.0	310.57	311.74	12718217.0
2020-06-18 16:00:00	SPY	ETF	311.74	311.97	311.16	311.24	8416004.0
2020-06-18 16:30:00	SPY	ETF	311.25	311.76	311.11	311.38	3863124.0
2020-06-18 17:00:00	SPY	ETF	311.28	311.766	311.28	311.33	128345.0
2020-06-18 17:30:00	SPY	ETF	311.32	311.78	311.3	311.31	79206.0
2020-06-18 18:00:00	SPY	ETF	311.31	312.07	311.1	311.96	171017.0
2020-06-18 18:30:00	SPY	ETF	311.93	312.18	311.92	312.1	76461.0
2020-06-18 19:00:00	SPY	ETF	312.14	312.69	312.12	312.68	52849.0
2020-06-18 19:30:00	SPY	ETF	312.69	313.03	312.69	312.93	169051.0
2020-06-18 04:00:00	QQQ	ETF	243.77	244.18	243.68	243.9	36477.0
2020-06-18 04:30:00	QQQ	ETF	243.8	244.93	243.8	244.76	42790.0
2020-06-18 05:00:00	QQQ	ETF	244.81	244.81	244.48	244.59	24675.0
2020-06-18 05:30:00	QQQ	ETF	244.65	245.02	244.18	244.26	32600.0
2020-06-18 06:00:00	QQQ	ETF	244.26	244.26	243.8	244.0	18529.0
2020-06-18 06:30:00	QQQ	ETF	244.21	244.34	243.85	243.91	16729.0
2020-06-18 07:00:00	QQQ	ETF	243.98	244.25	243.36	243.53	45080.0
2020-06-18 07:30:00	QQQ	ETF	243.6	243.69	242.88	242.97	120110.0
2020-06-18 08:00:00	QQQ	ETF	243.7401	244.03	242.67	243.36	170172.0
2020-06-18 08:30:00	QQQ	ETF	243.33	243.97	243.0	243.68	189277.0
2020-06-18 09:00:00	QQQ	ETF	243.64	243.67	243.12	243.3	164676.0
2020-06-18 09:30:00	QQQ	ETF	243.29	244.04	242.96	243.48	3317522.0
2020-06-18 10:00:00	QQQ	ETF	243.47	244.13	243.01	243.25	2190789.0
2020-06-18 10:30:00	QQQ	ETF	243.24	244.255	242.49	244.22	2779957.0
2020-06-18 11:00:00	QQQ	ETF	244.21	244.53	244.0	244.1293	1495884.0
2020-06-18 11:30:00	QQQ	ETF	244.12	244.25	243.39	243.54	1366352.0
2020-06-18 12:00:00	QQQ	ETF	243.5	243.93	243.19	243.82	1228850.0
2020-06-18 12:30:00	QQQ	ETF	243.82	243.9	243.48	243.79	1040343.0

> showing 50 of 19,716 rows — these rows as CSV

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