PREVIEW / etf_30min / 2018-11-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-23.parquet
  size:    281 KB
  rows:    9,482

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
2018-11-23 04:00:00	SPY	ETF	264.39	264.51	264.28	264.51	7798.0
2018-11-23 04:30:00	SPY	ETF	264.51	264.56	264.38	264.56	5505.0
2018-11-23 05:00:00	SPY	ETF	264.58	264.64	264.2	264.2	10478.0
2018-11-23 05:30:00	SPY	ETF	264.2	264.2	263.65	263.82	11837.0
2018-11-23 06:00:00	SPY	ETF	263.79	264.0	263.72	263.85	7321.0
2018-11-23 06:30:00	SPY	ETF	263.9	264.0	263.55	263.79	13101.0
2018-11-23 07:00:00	SPY	ETF	263.74	263.9	263.55	263.86	64465.0
2018-11-23 07:30:00	SPY	ETF	263.8	264.08	263.7	264.0	90235.0
2018-11-23 08:00:00	SPY	ETF	263.71	264.55	263.5	263.6	274463.0
2018-11-23 08:30:00	SPY	ETF	263.51	263.71	262.68	263.06	566644.0
2018-11-23 09:00:00	SPY	ETF	263.02	263.27	262.79	263.18	302960.0
2018-11-23 09:30:00	SPY	ETF	263.18	264.35	263.07	264.11	7496519.0
2018-11-23 10:00:00	SPY	ETF	264.1	264.41	263.43	263.56	4382651.0
2018-11-23 10:30:00	SPY	ETF	263.55	264.4	263.47	264.1675	4025992.0
2018-11-23 11:00:00	SPY	ETF	264.17	264.8234	264.12	264.47	2796970.0
2018-11-23 11:30:00	SPY	ETF	264.4703	264.55	263.69	263.755	3858735.0
2018-11-23 12:00:00	SPY	ETF	263.74	264.21	263.52	264.01	4760379.0
2018-11-23 12:30:00	SPY	ETF	264.0	264.3	263.24	263.36	8750877.0
2018-11-23 13:00:00	SPY	ETF	263.37	263.9757	262.91	262.98	2830584.0
2018-11-23 13:30:00	SPY	ETF	262.98	263.29	262.87	262.87	1019461.0
2018-11-23 14:00:00	SPY	ETF	262.97	263.03	262.84	262.9	102016.0
2018-11-23 14:30:00	SPY	ETF	262.9	263.32	262.87	262.87	78726.0
2018-11-23 15:00:00	SPY	ETF	262.93	262.93	262.8	262.8	34090.0
2018-11-23 15:30:00	SPY	ETF	262.93	263.0	262.76	262.94	17596.0
2018-11-23 16:00:00	SPY	ETF	262.94	276.2096	262.9	262.99	125825.0
2018-11-23 16:30:00	SPY	ETF	262.99	263.0	262.93	262.93	2868.0
2018-11-23 04:00:00	QQQ	ETF	159.72	159.82	159.58	159.82	6222.0
2018-11-23 04:30:00	QQQ	ETF	159.7	159.85	159.68	159.8	3499.0
2018-11-23 05:00:00	QQQ	ETF	159.85	159.85	159.54	159.54	1338.0
2018-11-23 05:30:00	QQQ	ETF	159.5	159.5	159.25	159.35	5900.0
2018-11-23 06:00:00	QQQ	ETF	159.3	159.46	159.3	159.43	2950.0
2018-11-23 06:30:00	QQQ	ETF	159.52	159.52	159.3	159.3	2831.0
2018-11-23 07:00:00	QQQ	ETF	159.44	159.67	159.24	159.56	23460.0
2018-11-23 07:30:00	QQQ	ETF	159.37	159.72	159.35	159.65	24362.0
2018-11-23 08:00:00	QQQ	ETF	159.55	159.71	159.09	159.41	162053.0
2018-11-23 08:30:00	QQQ	ETF	159.38	159.41	158.29	158.93	507866.0
2018-11-23 09:00:00	QQQ	ETF	158.9	159.19	158.86	159.14	154198.0
2018-11-23 09:30:00	QQQ	ETF	159.13	160.84	159.09	160.5	4019598.0
2018-11-23 10:00:00	QQQ	ETF	160.49	160.67	159.85	159.92	1892534.0
2018-11-23 10:30:00	QQQ	ETF	159.91	160.36	159.74	160.13	1971211.0
2018-11-23 11:00:00	QQQ	ETF	160.13	160.47	159.96	159.98	1493842.0
2018-11-23 11:30:00	QQQ	ETF	159.99	160.075	159.45	159.5	1900916.0
2018-11-23 12:00:00	QQQ	ETF	159.5	159.94	159.36	159.74	2044837.0
2018-11-23 12:30:00	QQQ	ETF	159.74	159.85	159.19	159.23	3597258.0
2018-11-23 13:00:00	QQQ	ETF	159.25	160.0489	158.95	159.16	1773551.0
2018-11-23 13:30:00	QQQ	ETF	159.16	159.21	159.04	159.1	62143.0
2018-11-23 14:00:00	QQQ	ETF	159.03	159.04	158.98	158.98	11003.0
2018-11-23 14:30:00	QQQ	ETF	159.05	159.09	158.86	158.95	19480.0
2018-11-23 15:00:00	QQQ	ETF	159.0	159.0069	158.96	158.96	1850.0
2018-11-23 15:30:00	QQQ	ETF	158.98	159.21	158.9304	158.96	78243.0

> showing 50 of 9,482 rows — these rows as CSV

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