PREVIEW / etf_30min / 2017-11-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-21.parquet
  size:    449 KB
  rows:    15,593

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
2017-11-21 04:00:00	SPY	ETF	258.27	258.27	258.2	258.24	1100.0
2017-11-21 04:30:00	SPY	ETF	258.35	258.4	258.33	258.4	1000.0
2017-11-21 05:00:00	SPY	ETF	258.5	258.8	258.5	258.8	6310.0
2017-11-21 05:30:00	SPY	ETF	258.88	258.88	258.85	258.87	405.0
2017-11-21 06:00:00	SPY	ETF	258.9	258.95	258.88	258.91	8000.0
2017-11-21 06:30:00	SPY	ETF	258.89	259.05	258.85	259.04	67659.0
2017-11-21 07:00:00	SPY	ETF	259.05	259.16	258.97	259.1	186569.0
2017-11-21 07:30:00	SPY	ETF	259.11	259.18	259.06	259.1	201723.0
2017-11-21 08:00:00	SPY	ETF	259.1	259.33	259.0	259.17	323475.0
2017-11-21 08:30:00	SPY	ETF	259.18	259.37	259.15	259.29	262891.0
2017-11-21 09:00:00	SPY	ETF	259.29	259.34	259.16	259.18	274948.0
2017-11-21 09:30:00	SPY	ETF	259.18	259.76	259.09	259.665	5778134.0
2017-11-21 10:00:00	SPY	ETF	259.665	259.98	259.62	259.97	4029309.0
2017-11-21 10:30:00	SPY	ETF	259.97	260.02	259.88	259.99	3940661.0
2017-11-21 11:00:00	SPY	ETF	259.99	260.05	259.86	259.915	3397241.0
2017-11-21 11:30:00	SPY	ETF	259.915	260.06	259.89	260.0	3044044.0
2017-11-21 12:00:00	SPY	ETF	260.01	260.04	259.935	259.95	1989547.0
2017-11-21 12:30:00	SPY	ETF	259.95	260.03	259.9	259.97	2265771.0
2017-11-21 13:00:00	SPY	ETF	259.97	260.04	259.94	260.015	1717799.0
2017-11-21 13:30:00	SPY	ETF	260.015	260.2	259.98	259.98	2923587.0
2017-11-21 14:00:00	SPY	ETF	259.98	260.05	259.9	260.02	5255273.0
2017-11-21 14:30:00	SPY	ETF	260.02	260.05	259.95	260.04	1975104.0
2017-11-21 15:00:00	SPY	ETF	260.04	260.06	259.81	259.92	3753206.0
2017-11-21 15:30:00	SPY	ETF	259.91	260.01	259.83	259.96	13908841.0
2017-11-21 16:00:00	SPY	ETF	259.96	259.99	259.74	259.76	7227284.0
2017-11-21 16:30:00	SPY	ETF	259.9734	259.9734	259.75	259.77	1492928.0
2017-11-21 17:00:00	SPY	ETF	259.75	259.77	259.69	259.71	88292.0
2017-11-21 17:30:00	SPY	ETF	259.71	259.73	259.68	259.73	87495.0
2017-11-21 18:00:00	SPY	ETF	259.73	259.82	259.7	259.82	87863.0
2017-11-21 18:30:00	SPY	ETF	259.82	259.84	259.8	259.81	9697.0
2017-11-21 19:00:00	SPY	ETF	259.79	259.8	259.64	259.64	55748.0
2017-11-21 19:30:00	SPY	ETF	259.66	259.73	259.65	259.69	36462.0
2017-11-21 05:00:00	QQQ	ETF	154.04	154.3	154.04	154.3	2450.0
2017-11-21 05:30:00	QQQ	ETF	154.25	154.35	154.25	154.3	15900.0
2017-11-21 06:00:00	QQQ	ETF	154.36	154.36	154.33	154.33	1632.0
2017-11-21 06:30:00	QQQ	ETF	154.32	154.32	154.31	154.32	4050.0
2017-11-21 07:00:00	QQQ	ETF	154.37	154.48	154.35	154.48	11248.0
2017-11-21 07:30:00	QQQ	ETF	154.4	154.57	154.39	154.54	40580.0
2017-11-21 08:00:00	QQQ	ETF	154.54	154.63	154.53	154.54	93775.0
2017-11-21 08:30:00	QQQ	ETF	154.57	154.66	154.56	154.64	84220.0
2017-11-21 09:00:00	QQQ	ETF	154.63	154.65	154.5	154.52	36993.0
2017-11-21 09:30:00	QQQ	ETF	154.51	155.32	154.485	155.275	3119740.0
2017-11-21 10:00:00	QQQ	ETF	155.28	155.47	155.18	155.43	1952076.0
2017-11-21 10:30:00	QQQ	ETF	155.4375	155.45	155.31	155.425	1329530.0
2017-11-21 11:00:00	QQQ	ETF	155.4242	155.52	155.37	155.43	843092.0
2017-11-21 11:30:00	QQQ	ETF	155.44	155.555	155.41	155.5	1030382.0
2017-11-21 12:00:00	QQQ	ETF	155.5	155.54	155.394	155.4	850816.0
2017-11-21 12:30:00	QQQ	ETF	155.41	155.4675	155.36	155.4	545459.0
2017-11-21 13:00:00	QQQ	ETF	155.41	155.44	155.37	155.425	347354.0
2017-11-21 13:30:00	QQQ	ETF	155.43	155.57	155.43	155.45	612458.0

> showing 50 of 15,593 rows — these rows as CSV

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