PREVIEW / etf_30min / 2017-12-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-01.parquet
  size:    472 KB
  rows:    16,266

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-12-01 04:00:00	SPY	ETF	264.11	264.31	264.05	264.12	11013.0
2017-12-01 04:30:00	SPY	ETF	264.14	264.35	264.14	264.35	28300.0
2017-12-01 05:00:00	SPY	ETF	264.43	264.43	264.29	264.29	200.0
2017-12-01 05:30:00	SPY	ETF	264.21	264.21	263.34	263.58	24103.0
2017-12-01 06:00:00	SPY	ETF	263.48	263.96	263.48	263.94	69417.0
2017-12-01 06:30:00	SPY	ETF	263.94	264.07	263.77	263.77	69959.0
2017-12-01 07:00:00	SPY	ETF	263.86	264.04	263.8	263.93	81399.0
2017-12-01 07:30:00	SPY	ETF	263.9	264.25	263.9	264.18	458359.0
2017-12-01 08:00:00	SPY	ETF	264.0	264.86	263.82	264.76	1163284.0
2017-12-01 08:30:00	SPY	ETF	264.75	264.92	264.6	264.66	633359.0
2017-12-01 09:00:00	SPY	ETF	264.68	265.0	264.68	264.76	1047927.0
2017-12-01 09:30:00	SPY	ETF	264.76	265.09	264.5	264.77	7286985.0
2017-12-01 10:00:00	SPY	ETF	264.76	265.31	264.53	265.06	6764401.0
2017-12-01 10:30:00	SPY	ETF	265.065	265.28	264.75	265.14	4387537.0
2017-12-01 11:00:00	SPY	ETF	265.15	265.18	261.52	261.7	28231539.0
2017-12-01 11:30:00	SPY	ETF	261.69	263.21	260.76	263.2	25536865.0
2017-12-01 12:00:00	SPY	ETF	263.21	263.64	262.81	263.31	14821112.0
2017-12-01 12:30:00	SPY	ETF	263.32	263.78	263.01	263.73	10169120.0
2017-12-01 13:00:00	SPY	ETF	263.71	263.93	263.52	263.915	6942133.0
2017-12-01 13:30:00	SPY	ETF	263.92	264.25	263.75	263.98	5062940.0
2017-12-01 14:00:00	SPY	ETF	263.99	264.18	263.8756	264.12	3231217.0
2017-12-01 14:30:00	SPY	ETF	264.12	264.18	263.67	263.865	5050243.0
2017-12-01 15:00:00	SPY	ETF	263.86	264.12	263.58	264.06	7509238.0
2017-12-01 15:30:00	SPY	ETF	264.065	264.54	264.06	264.44	17896933.0
2017-12-01 16:00:00	SPY	ETF	264.44	264.73	264.43	264.7	13232162.0
2017-12-01 16:30:00	SPY	ETF	264.7	264.74	264.38	264.52	1075965.0
2017-12-01 17:00:00	SPY	ETF	264.51	264.92	264.46	264.87	1349466.0
2017-12-01 17:30:00	SPY	ETF	264.85	264.85	264.25	264.3	773644.0
2017-12-01 18:00:00	SPY	ETF	264.28	264.4	264.1	264.4	114915.0
2017-12-01 18:30:00	SPY	ETF	264.4	264.47	264.36	264.37	119984.0
2017-12-01 19:00:00	SPY	ETF	264.38	264.39	264.34	264.39	4079.0
2017-12-01 19:30:00	SPY	ETF	264.39	264.4	264.3	264.38	8482.0
2017-12-01 04:00:00	QQQ	ETF	154.54	154.63	154.41	154.42	42400.0
2017-12-01 04:30:00	QQQ	ETF	154.44	154.62	154.44	154.62	7095.0
2017-12-01 05:00:00	QQQ	ETF	154.58	154.6	154.54	154.56	16700.0
2017-12-01 05:30:00	QQQ	ETF	154.5	154.53	153.81	153.94	28658.0
2017-12-01 06:00:00	QQQ	ETF	153.85	154.21	153.85	154.21	17844.0
2017-12-01 06:30:00	QQQ	ETF	154.21	154.26	154.1	154.1	4900.0
2017-12-01 07:00:00	QQQ	ETF	154.16	154.32	154.05	154.15	24295.0
2017-12-01 07:30:00	QQQ	ETF	154.08	154.36	154.08	154.31	65515.0
2017-12-01 08:00:00	QQQ	ETF	154.13	154.7	154.13	154.64	68336.0
2017-12-01 08:30:00	QQQ	ETF	154.66	154.75	154.4	154.5	110947.0
2017-12-01 09:00:00	QQQ	ETF	154.49	154.64	154.1	154.17	536227.0
2017-12-01 09:30:00	QQQ	ETF	154.18	154.91	154.15	154.52	4491583.0
2017-12-01 10:00:00	QQQ	ETF	154.525	155.24	154.44	155.02	3286422.0
2017-12-01 10:30:00	QQQ	ETF	155.03	155.18	154.71	154.99	1564082.0
2017-12-01 11:00:00	QQQ	ETF	154.99	155.11	152.87	153.0	9085306.0
2017-12-01 11:30:00	QQQ	ETF	152.9965	153.87	152.26	153.68	10215974.0
2017-12-01 12:00:00	QQQ	ETF	153.68	154.04	153.37	153.67	4378828.0
2017-12-01 12:30:00	QQQ	ETF	153.68	154.175	153.24	154.13	2788626.0

> showing 50 of 16,266 rows — these rows as CSV

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