PREVIEW / etf_30min / 2019-02-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-28.parquet
  size:    488 KB
  rows:    17,024

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
2019-02-28 04:00:00	SPY	ETF	278.66	278.77	278.66	278.77	5396.0
2019-02-28 04:30:00	SPY	ETF	278.72	278.83	278.66	278.77	2323.0
2019-02-28 05:00:00	SPY	ETF	278.75	278.75	278.61	278.61	7601.0
2019-02-28 05:30:00	SPY	ETF	278.7	278.8	278.7	278.75	7400.0
2019-02-28 06:00:00	SPY	ETF	278.74	278.85	278.65	278.8	6297.0
2019-02-28 06:30:00	SPY	ETF	278.78	278.86	278.73	278.86	12200.0
2019-02-28 07:00:00	SPY	ETF	278.87	278.98	278.71	278.91	99444.0
2019-02-28 07:30:00	SPY	ETF	278.92	279.15	278.82	279.01	102761.0
2019-02-28 08:00:00	SPY	ETF	278.85	279.12	278.3	278.92	101999.0
2019-02-28 08:30:00	SPY	ETF	278.98	279.3	278.92	279.07	237073.0
2019-02-28 09:00:00	SPY	ETF	279.06	279.1	278.91	278.96	241722.0
2019-02-28 09:30:00	SPY	ETF	278.96	279.35	278.73	279.1	5324189.0
2019-02-28 10:00:00	SPY	ETF	279.1	279.1	278.46	278.74	4608394.0
2019-02-28 10:30:00	SPY	ETF	278.75	279.09	278.4	278.71	3674611.0
2019-02-28 11:00:00	SPY	ETF	278.71	279.09	278.42	278.92	3033144.0
2019-02-28 11:30:00	SPY	ETF	278.92	279.29	278.88	279.078	2069870.0
2019-02-28 12:00:00	SPY	ETF	279.08	279.45	279.0	279.39	1560187.0
2019-02-28 12:30:00	SPY	ETF	279.385	279.41	279.17	279.41	1637248.0
2019-02-28 13:00:00	SPY	ETF	279.41	279.44	279.09	279.125	1958147.0
2019-02-28 13:30:00	SPY	ETF	279.13	279.32	279.02	279.1557	1508770.0
2019-02-28 14:00:00	SPY	ETF	279.155	279.275	278.94	279.195	2207408.0
2019-02-28 14:30:00	SPY	ETF	279.19	279.19	278.67	278.845	3434064.0
2019-02-28 15:00:00	SPY	ETF	278.8426	278.99	278.695	278.925	4217278.0
2019-02-28 15:30:00	SPY	ETF	278.92	279.19	278.32	278.54	17620581.0
2019-02-28 16:00:00	SPY	ETF	278.54	279.04	278.46	278.86	8933801.0
2019-02-28 16:30:00	SPY	ETF	278.86	278.96	278.5293	278.74	3648200.0
2019-02-28 17:00:00	SPY	ETF	278.76	278.77	278.5289	278.63	347584.0
2019-02-28 17:30:00	SPY	ETF	278.63	278.63	278.58	278.63	77673.0
2019-02-28 18:00:00	SPY	ETF	278.62	278.66	278.34	278.49	71470.0
2019-02-28 18:30:00	SPY	ETF	278.49	278.62	278.48	278.59	15333.0
2019-02-28 19:00:00	SPY	ETF	278.57	278.8	278.56	278.64	25991.0
2019-02-28 19:30:00	SPY	ETF	278.7	278.82	278.7	278.8	36434.0
2019-02-28 04:00:00	QQQ	ETF	172.9	172.9	172.78	172.81	19300.0
2019-02-28 04:30:00	QQQ	ETF	172.84	172.9	172.8	172.86	5588.0
2019-02-28 05:00:00	QQQ	ETF	172.75	172.79	172.72	172.77	8700.0
2019-02-28 05:30:00	QQQ	ETF	172.78	172.85	172.78	172.82	32630.0
2019-02-28 06:00:00	QQQ	ETF	172.81	172.95	172.8	172.86	10056.0
2019-02-28 06:30:00	QQQ	ETF	172.85	172.9	172.8	172.89	13000.0
2019-02-28 07:00:00	QQQ	ETF	172.91	172.97	172.82	172.92	21643.0
2019-02-28 07:30:00	QQQ	ETF	172.89	173.1	172.85	173.03	79867.0
2019-02-28 08:00:00	QQQ	ETF	172.9101	173.08	172.85	172.98	72961.0
2019-02-28 08:30:00	QQQ	ETF	173.02	173.29	173.0	173.09	150965.0
2019-02-28 09:00:00	QQQ	ETF	173.08	173.15	173.0	173.02	43516.0
2019-02-28 09:30:00	QQQ	ETF	173.04	173.595	172.91	173.35	2559355.0
2019-02-28 10:00:00	QQQ	ETF	173.34	173.34	172.7	172.94	2448019.0
2019-02-28 10:30:00	QQQ	ETF	172.94	173.26	172.84	173.08	1853850.0
2019-02-28 11:00:00	QQQ	ETF	173.08	173.39	172.88	173.3	1219761.0
2019-02-28 11:30:00	QQQ	ETF	173.31	173.68	173.2701	173.52	1334114.0
2019-02-28 12:00:00	QQQ	ETF	173.53	173.81	173.42	173.75	893638.0
2019-02-28 12:30:00	QQQ	ETF	173.76	173.78	173.63	173.75	679621.0

> showing 50 of 17,024 rows — these rows as CSV

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