PREVIEW / etf_30min / 2020-03-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-06.parquet
  size:    609 KB
  rows:    21,883

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-03-06 04:00:00	SPY	ETF	298.71	299.6	297.82	298.05	60836.0
2020-03-06 04:30:00	SPY	ETF	298.06	298.12	295.9	295.91	113706.0
2020-03-06 05:00:00	SPY	ETF	295.87	295.97	294.2	294.29	153251.0
2020-03-06 05:30:00	SPY	ETF	294.18	294.65	293.0	294.35	121267.0
2020-03-06 06:00:00	SPY	ETF	294.22	295.14	293.27	293.7	275539.0
2020-03-06 06:30:00	SPY	ETF	293.8	295.41	293.8	294.54	260205.0
2020-03-06 07:00:00	SPY	ETF	294.5	295.38	293.7	293.79	651068.0
2020-03-06 07:30:00	SPY	ETF	293.8	294.38	291.9	293.27	733649.0
2020-03-06 08:00:00	SPY	ETF	298.87	302.8	291.9798	292.92	1707267.0
2020-03-06 08:30:00	SPY	ETF	293.07	294.63	292.18	293.4	1204825.0
2020-03-06 09:00:00	SPY	ETF	293.3	293.3	291.0	293.14	1565505.0
2020-03-06 09:30:00	SPY	ETF	293.15	294.74	291.5367	293.35	23124043.0
2020-03-06 10:00:00	SPY	ETF	293.34	296.63	292.61	296.42	17703947.0
2020-03-06 10:30:00	SPY	ETF	296.4	297.97	295.07	297.08	14362554.0
2020-03-06 11:00:00	SPY	ETF	297.09	297.47	294.76	295.15	10535398.0
2020-03-06 11:30:00	SPY	ETF	295.13	296.23	294.12	294.9401	8862899.0
2020-03-06 12:00:00	SPY	ETF	294.92	295.16	292.99	293.205	8708831.0
2020-03-06 12:30:00	SPY	ETF	293.205	296.08	293.0	294.55	8816656.0
2020-03-06 13:00:00	SPY	ETF	294.53	296.72	294.48	295.59	7172775.0
2020-03-06 13:30:00	SPY	ETF	295.59	296.12	293.37	293.63	8728542.0
2020-03-06 14:00:00	SPY	ETF	293.65	293.97	292.55	293.45	10547450.0
2020-03-06 14:30:00	SPY	ETF	293.44	293.75	290.57	291.01	15408582.0
2020-03-06 15:00:00	SPY	ETF	291.0	293.27	290.23	292.18	17813318.0
2020-03-06 15:30:00	SPY	ETF	292.18	298.78	291.75	297.42	46872540.0
2020-03-06 16:00:00	SPY	ETF	297.49	297.49	296.0	296.86	18566033.0
2020-03-06 16:30:00	SPY	ETF	296.85	297.46	296.34	296.67	1125983.0
2020-03-06 17:00:00	SPY	ETF	296.6	297.46	296.1	296.14	627501.0
2020-03-06 17:30:00	SPY	ETF	296.2	296.24	295.49	295.5	229147.0
2020-03-06 18:00:00	SPY	ETF	295.6	296.15	295.11	295.65	190001.0
2020-03-06 18:30:00	SPY	ETF	295.6	295.6	295.3	295.4	48288.0
2020-03-06 19:00:00	SPY	ETF	295.35	296.0	295.25	295.59	32077.0
2020-03-06 19:30:00	SPY	ETF	295.58	295.7	295.23	295.5	65221.0
2020-03-06 04:00:00	QQQ	ETF	208.83	209.42	208.04	208.3	27217.0
2020-03-06 04:30:00	QQQ	ETF	208.24	208.26	206.68	206.68	78715.0
2020-03-06 05:00:00	QQQ	ETF	206.67	206.76	205.44	205.5	96563.0
2020-03-06 05:30:00	QQQ	ETF	205.57	205.83	204.48	205.29	168190.0
2020-03-06 06:00:00	QQQ	ETF	205.27	205.69	204.5	204.82	79375.0
2020-03-06 06:30:00	QQQ	ETF	204.98	205.6	204.98	205.1	95676.0
2020-03-06 07:00:00	QQQ	ETF	205.06	205.86	204.71	204.81	336765.0
2020-03-06 07:30:00	QQQ	ETF	204.75	205.25	203.5	204.35	403122.0
2020-03-06 08:00:00	QQQ	ETF	205.4701	209.61	203.55	204.1	464392.0
2020-03-06 08:30:00	QQQ	ETF	204.33	205.25	203.7	204.84	696071.0
2020-03-06 09:00:00	QQQ	ETF	204.59	204.67	202.88	204.67	1241777.0
2020-03-06 09:30:00	QQQ	ETF	204.67	206.5	204.11	205.4299	9412030.0
2020-03-06 10:00:00	QQQ	ETF	205.43	207.8	204.85	207.68	7078815.0
2020-03-06 10:30:00	QQQ	ETF	207.67	208.51	206.6	207.65	5808518.0
2020-03-06 11:00:00	QQQ	ETF	207.66	207.91	206.04	206.49	5078182.0
2020-03-06 11:30:00	QQQ	ETF	206.455	207.25	205.47	205.86	3712229.0
2020-03-06 12:00:00	QQQ	ETF	205.86	206.04	204.64	204.7573	2858085.0
2020-03-06 12:30:00	QQQ	ETF	204.77	206.71	204.62	205.49	3371926.0

> showing 50 of 21,883 rows — these rows as CSV

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