PREVIEW / etf_30min / 2017-12-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-05.parquet
  size:    460 KB
  rows:    15,837

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-05 04:00:00	SPY	ETF	264.3	264.3	264.3	264.3	2500.0
2017-12-05 04:30:00	SPY	ETF	264.32	264.46	264.32	264.46	700.0
2017-12-05 05:00:00	SPY	ETF	264.46	264.46	264.03	264.03	500.0
2017-12-05 05:30:00	SPY	ETF	264.02	264.05	263.83	263.83	1804.0
2017-12-05 06:00:00	SPY	ETF	263.97	264.07	263.95	264.01	11512.0
2017-12-05 06:30:00	SPY	ETF	264.01	264.31	264.0	264.26	11321.0
2017-12-05 07:00:00	SPY	ETF	264.3	264.5	264.24	264.38	44126.0
2017-12-05 07:30:00	SPY	ETF	264.38	264.69	264.29	264.62	244865.0
2017-12-05 08:00:00	SPY	ETF	264.14	264.74	264.14	264.65	233333.0
2017-12-05 08:30:00	SPY	ETF	264.63	264.68	264.32	264.33	212530.0
2017-12-05 09:00:00	SPY	ETF	264.35	264.65	264.32	264.43	421620.0
2017-12-05 09:30:00	SPY	ETF	264.43	264.46	264.09	264.17	5807330.0
2017-12-05 10:00:00	SPY	ETF	264.17	264.63	264.14	264.48	6946439.0
2017-12-05 10:30:00	SPY	ETF	264.48	264.89	264.25	264.8	6892288.0
2017-12-05 11:00:00	SPY	ETF	264.805	265.15	264.805	265.05	3646896.0
2017-12-05 11:30:00	SPY	ETF	265.06	265.125	264.57	264.63	2597190.0
2017-12-05 12:00:00	SPY	ETF	264.63	264.66	264.21	264.42	4666075.0
2017-12-05 12:30:00	SPY	ETF	264.41	264.58	264.16	264.2345	2726215.0
2017-12-05 13:00:00	SPY	ETF	264.2375	264.515	264.11	264.4	2192946.0
2017-12-05 13:30:00	SPY	ETF	264.4075	264.48	264.22	264.35	1313227.0
2017-12-05 14:00:00	SPY	ETF	264.35	264.42	263.7	263.91	4627865.0
2017-12-05 14:30:00	SPY	ETF	263.92	263.94	263.35	263.495	5484007.0
2017-12-05 15:00:00	SPY	ETF	263.5	263.66	263.2	263.57	7797390.0
2017-12-05 15:30:00	SPY	ETF	263.56	263.585	263.04	263.2	15360571.0
2017-12-05 16:00:00	SPY	ETF	263.2	263.57	263.08	263.12	4347208.0
2017-12-05 16:30:00	SPY	ETF	263.13	263.5487	263.01	263.05	549785.0
2017-12-05 17:00:00	SPY	ETF	263.05	263.08	262.93	262.97	91513.0
2017-12-05 17:30:00	SPY	ETF	262.98	262.98	262.94	262.97	43082.0
2017-12-05 18:00:00	SPY	ETF	263.0	263.23	263.0	263.22	69172.0
2017-12-05 18:30:00	SPY	ETF	263.21	263.25	263.14	263.22	23208.0
2017-12-05 19:00:00	SPY	ETF	263.24	263.43	263.18	263.39	9714.0
2017-12-05 19:30:00	SPY	ETF	263.33	263.4	263.32	263.38	9077.0
2017-12-05 04:00:00	QQQ	ETF	152.75	152.75	152.57	152.57	16099.0
2017-12-05 04:30:00	QQQ	ETF	152.44	152.55	152.44	152.55	1185.0
2017-12-05 05:00:00	QQQ	ETF	152.54	152.54	152.14	152.18	3220.0
2017-12-05 05:30:00	QQQ	ETF	152.22	152.31	152.09	152.09	4900.0
2017-12-05 06:00:00	QQQ	ETF	152.08	152.08	151.94	151.97	30110.0
2017-12-05 06:30:00	QQQ	ETF	152.01	152.29	152.01	152.28	38966.0
2017-12-05 07:00:00	QQQ	ETF	152.3	152.43	152.2	152.43	43989.0
2017-12-05 07:30:00	QQQ	ETF	152.44	152.92	152.43	152.8	121165.0
2017-12-05 08:00:00	QQQ	ETF	152.82	152.89	152.22	152.84	127622.0
2017-12-05 08:30:00	QQQ	ETF	152.88	152.97	152.75	152.76	129749.0
2017-12-05 09:00:00	QQQ	ETF	152.77	152.9	152.44	152.66	306360.0
2017-12-05 09:30:00	QQQ	ETF	152.64	153.94	152.1	153.68	6148607.0
2017-12-05 10:00:00	QQQ	ETF	153.685	154.08	153.57	153.78	3460944.0
2017-12-05 10:30:00	QQQ	ETF	153.77	154.1	153.66	154.06	2078600.0
2017-12-05 11:00:00	QQQ	ETF	154.0725	154.55	154.0725	154.365	3013396.0
2017-12-05 11:30:00	QQQ	ETF	154.36	154.45	153.8817	153.96	2113969.0
2017-12-05 12:00:00	QQQ	ETF	153.95	154.03	153.63	153.83	2164809.0
2017-12-05 12:30:00	QQQ	ETF	153.82	154.04	153.47	153.58	1324657.0

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

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