PREVIEW / etf_30min / 2019-02-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-01.parquet
  size:    502 KB
  rows:    17,533

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-01 04:00:00	SPY	ETF	270.07	270.21	270.02	270.12	11723.0
2019-02-01 04:30:00	SPY	ETF	270.2	270.24	270.0	270.07	5858.0
2019-02-01 05:00:00	SPY	ETF	270.07	270.14	270.04	270.11	2069.0
2019-02-01 05:30:00	SPY	ETF	270.14	270.2	269.9	269.98	14777.0
2019-02-01 06:00:00	SPY	ETF	270.01	270.14	269.96	269.99	29724.0
2019-02-01 06:30:00	SPY	ETF	269.91	269.99	269.82	269.89	13574.0
2019-02-01 07:00:00	SPY	ETF	269.92	269.94	269.71	269.82	58727.0
2019-02-01 07:30:00	SPY	ETF	269.81	269.85	269.5	269.51	128507.0
2019-02-01 08:00:00	SPY	ETF	269.5	270.34	269.3	269.47	382343.0
2019-02-01 08:30:00	SPY	ETF	269.6	270.55	269.6	270.39	1371566.0
2019-02-01 09:00:00	SPY	ETF	270.39	270.46	270.02	270.16	933561.0
2019-02-01 09:30:00	SPY	ETF	270.15	270.49	269.53	269.55	8939242.0
2019-02-01 10:00:00	SPY	ETF	269.56	271.2	269.555	270.99	8820065.0
2019-02-01 10:30:00	SPY	ETF	270.99	271.15	270.13	270.14	5748384.0
2019-02-01 11:00:00	SPY	ETF	270.14	270.76	269.8	270.5515	5778308.0
2019-02-01 11:30:00	SPY	ETF	270.565	271.02	270.4401	270.98	2375780.0
2019-02-01 12:00:00	SPY	ETF	270.99	271.01	270.08	270.3	2973555.0
2019-02-01 12:30:00	SPY	ETF	270.3	270.45	270.0	270.305	3026996.0
2019-02-01 13:00:00	SPY	ETF	270.3	270.47	269.93	270.22	2366646.0
2019-02-01 13:30:00	SPY	ETF	270.21	270.3665	269.8	270.1399	3216495.0
2019-02-01 14:00:00	SPY	ETF	270.135	270.15	269.45	269.62	5765650.0
2019-02-01 14:30:00	SPY	ETF	269.62	269.88	269.29	269.461	5422028.0
2019-02-01 15:00:00	SPY	ETF	269.45	269.68	269.18	269.6675	5651055.0
2019-02-01 15:30:00	SPY	ETF	269.67	270.24	269.64	270.09	10682892.0
2019-02-01 16:00:00	SPY	ETF	270.08	270.177	270.01	270.13	10209665.0
2019-02-01 16:30:00	SPY	ETF	270.1	270.22	270.05	270.15	429119.0
2019-02-01 17:00:00	SPY	ETF	270.15	270.15	270.06	270.11	13549.0
2019-02-01 17:30:00	SPY	ETF	270.1	270.12	270.06	270.12	11906.0
2019-02-01 18:00:00	SPY	ETF	270.1	270.11	270.01	270.11	10690.0
2019-02-01 18:30:00	SPY	ETF	270.1	270.18	270.05	270.18	6406.0
2019-02-01 19:00:00	SPY	ETF	270.12	270.14	270.04	270.04	10417.0
2019-02-01 19:30:00	SPY	ETF	270.05	270.09	270.05	270.07	12166.0
2019-02-01 04:00:00	QQQ	ETF	167.89	167.89	167.61	167.62	22840.0
2019-02-01 04:30:00	QQQ	ETF	167.63	167.63	167.49	167.6	12055.0
2019-02-01 05:00:00	QQQ	ETF	167.58	167.65	167.53	167.61	18003.0
2019-02-01 05:30:00	QQQ	ETF	167.71	167.72	167.46	167.54	9443.0
2019-02-01 06:00:00	QQQ	ETF	167.52	167.63	167.5	167.5	19025.0
2019-02-01 06:30:00	QQQ	ETF	167.49	167.49	167.35	167.42	23914.0
2019-02-01 07:00:00	QQQ	ETF	167.42	167.48	167.34	167.47	34620.0
2019-02-01 07:30:00	QQQ	ETF	167.48	167.56	167.22	167.23	121729.0
2019-02-01 08:00:00	QQQ	ETF	167.24	167.78	167.0	167.1701	169419.0
2019-02-01 08:30:00	QQQ	ETF	167.18	167.89	167.16	167.65	295251.0
2019-02-01 09:00:00	QQQ	ETF	167.66	167.66	167.28	167.37	197295.0
2019-02-01 09:30:00	QQQ	ETF	167.37	168.25	167.24	167.38	4416932.0
2019-02-01 10:00:00	QQQ	ETF	167.375	168.6	167.375	168.42	3274570.0
2019-02-01 10:30:00	QQQ	ETF	168.42	168.55	167.79	167.8	1898346.0
2019-02-01 11:00:00	QQQ	ETF	167.8	168.24	167.605	168.04	1544142.0
2019-02-01 11:30:00	QQQ	ETF	168.04	168.46	167.98	168.3797	815666.0
2019-02-01 12:00:00	QQQ	ETF	168.39	168.39	167.77	167.91	1289545.0
2019-02-01 12:30:00	QQQ	ETF	167.92	167.97	167.62	167.78	1228566.0

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

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