PREVIEW / etf_30min / 2020-01-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-21.parquet
  size:    564 KB
  rows:    20,107

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-01-21 04:00:00	SPY	ETF	330.7	330.75	330.34	330.44	20928.0
2020-01-21 04:30:00	SPY	ETF	330.37	330.37	330.14	330.34	22655.0
2020-01-21 05:00:00	SPY	ETF	330.4	330.47	330.3	330.43	19581.0
2020-01-21 05:30:00	SPY	ETF	330.43	330.44	330.28	330.39	7093.0
2020-01-21 06:00:00	SPY	ETF	330.52	330.65	330.4	330.4	13998.0
2020-01-21 06:30:00	SPY	ETF	330.47	330.74	330.46	330.72	55203.0
2020-01-21 07:00:00	SPY	ETF	330.76	330.92	330.73	330.8	212644.0
2020-01-21 07:30:00	SPY	ETF	330.82	330.89	330.68	330.79	112598.0
2020-01-21 08:00:00	SPY	ETF	330.715	330.93	330.1	330.84	265910.0
2020-01-21 08:30:00	SPY	ETF	330.8	330.88	330.62	330.62	132792.0
2020-01-21 09:00:00	SPY	ETF	330.66	330.94	330.65	330.89	191100.0
2020-01-21 09:30:00	SPY	ETF	330.9	331.56	330.86	331.25	7416401.0
2020-01-21 10:00:00	SPY	ETF	331.24	331.54	330.95	331.3714	5221529.0
2020-01-21 10:30:00	SPY	ETF	331.37	331.51	331.1533	331.17	5667087.0
2020-01-21 11:00:00	SPY	ETF	331.17	331.8	331.14	331.74	9520280.0
2020-01-21 11:30:00	SPY	ETF	331.745	332.08	331.73	331.99	4738974.0
2020-01-21 12:00:00	SPY	ETF	331.99	332.09	331.9	332.0	2267884.0
2020-01-21 12:30:00	SPY	ETF	332.0	332.18	331.943	332.02	2031660.0
2020-01-21 13:00:00	SPY	ETF	332.015	332.09	331.4	331.54	3923436.0
2020-01-21 13:30:00	SPY	ETF	331.53	331.57	330.95	331.0	4132371.0
2020-01-21 14:00:00	SPY	ETF	331.0	331.5	330.82	331.21	3770473.0
2020-01-21 14:30:00	SPY	ETF	331.22	331.42	330.97	331.4	2322826.0
2020-01-21 15:00:00	SPY	ETF	331.4	331.76	331.38	331.57	2214527.0
2020-01-21 15:30:00	SPY	ETF	331.5701	331.74	331.02	331.31	8554186.0
2020-01-21 16:00:00	SPY	ETF	331.31	331.46	331.09	331.17	10418357.0
2020-01-21 16:30:00	SPY	ETF	331.17	331.3	331.15	331.22	1375001.0
2020-01-21 17:00:00	SPY	ETF	331.15	331.3	331.12	331.2	414683.0
2020-01-21 17:30:00	SPY	ETF	331.2	331.3	331.16	331.25	20623.0
2020-01-21 18:00:00	SPY	ETF	331.29	331.4	331.28	331.31	64963.0
2020-01-21 18:30:00	SPY	ETF	331.3	331.33	331.15	331.2	16048.0
2020-01-21 19:00:00	SPY	ETF	331.3	331.61	331.27	331.59	31807.0
2020-01-21 19:30:00	SPY	ETF	331.61	331.62	331.43	331.5	22155.0
2020-01-21 04:00:00	QQQ	ETF	222.35	222.35	222.1	222.16	14584.0
2020-01-21 04:30:00	QQQ	ETF	222.09	222.11	221.93	222.05	21865.0
2020-01-21 05:00:00	QQQ	ETF	222.04	222.13	222.04	222.12	13196.0
2020-01-21 05:30:00	QQQ	ETF	222.09	222.15	222.0	222.13	31765.0
2020-01-21 06:00:00	QQQ	ETF	222.1	222.28	222.05	222.1	26016.0
2020-01-21 06:30:00	QQQ	ETF	222.1	222.34	222.1	222.3	36328.0
2020-01-21 07:00:00	QQQ	ETF	222.35	222.42	222.3	222.4	80178.0
2020-01-21 07:30:00	QQQ	ETF	222.4	222.45	222.32	222.4	55053.0
2020-01-21 08:00:00	QQQ	ETF	222.35	223.38	221.94	222.49	63580.0
2020-01-21 08:30:00	QQQ	ETF	222.49	222.56	222.4	222.4	90553.0
2020-01-21 09:00:00	QQQ	ETF	222.45	222.74	222.45	222.72	208242.0
2020-01-21 09:30:00	QQQ	ETF	222.73	223.25	222.69	223.1	2978963.0
2020-01-21 10:00:00	QQQ	ETF	223.1	223.4	222.9002	223.18	1488188.0
2020-01-21 10:30:00	QQQ	ETF	223.1741	223.36	223.06	223.07	895568.0
2020-01-21 11:00:00	QQQ	ETF	223.05	223.6499	223.01	223.57	982349.0
2020-01-21 11:30:00	QQQ	ETF	223.57	223.84	223.57	223.64	868750.0
2020-01-21 12:00:00	QQQ	ETF	223.64	223.73	223.54	223.68	401668.0
2020-01-21 12:30:00	QQQ	ETF	223.68	223.73	223.57	223.62	483708.0

> showing 50 of 20,107 rows — these rows as CSV

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