PREVIEW / etf_30min / 2017-09-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-11.parquet
  size:    440 KB
  rows:    15,391

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-09-11 04:00:00	SPY	ETF	247.87	247.98	247.85	247.98	19086.0
2017-09-11 04:30:00	SPY	ETF	247.96	248.11	247.96	248.04	6076.0
2017-09-11 05:00:00	SPY	ETF	248.09	248.09	248.01	248.08	5508.0
2017-09-11 05:30:00	SPY	ETF	248.03	248.08	247.98	248.08	21000.0
2017-09-11 06:00:00	SPY	ETF	248.08	248.11	248.02	248.09	6193.0
2017-09-11 06:30:00	SPY	ETF	248.09	248.09	248.01	248.06	53335.0
2017-09-11 07:00:00	SPY	ETF	248.04	248.06	247.88	247.88	56777.0
2017-09-11 07:30:00	SPY	ETF	247.88	247.9	247.77	247.81	65831.0
2017-09-11 08:00:00	SPY	ETF	247.82	247.93	247.81	247.85	97045.0
2017-09-11 08:30:00	SPY	ETF	247.86	247.97	247.85	247.93	539674.0
2017-09-11 09:00:00	SPY	ETF	247.92	248.04	247.92	248.03	323449.0
2017-09-11 09:30:00	SPY	ETF	248.04	248.65	248.02	248.53	8922277.0
2017-09-11 10:00:00	SPY	ETF	248.53	248.79	248.525	248.66	5077328.0
2017-09-11 10:30:00	SPY	ETF	248.67	248.73	248.5	248.55	5068696.0
2017-09-11 11:00:00	SPY	ETF	248.56	248.65	248.52	248.61	1787471.0
2017-09-11 11:30:00	SPY	ETF	248.61	248.95	248.6	248.9	3453595.0
2017-09-11 12:00:00	SPY	ETF	248.9	249.04	248.81	249.01	2847813.0
2017-09-11 12:30:00	SPY	ETF	249.02	249.3	248.99	249.12	3356768.0
2017-09-11 13:00:00	SPY	ETF	249.12	249.24	249.1	249.18	2710229.0
2017-09-11 13:30:00	SPY	ETF	249.1863	249.22	249.11	249.16	1613966.0
2017-09-11 14:00:00	SPY	ETF	249.17	249.22	249.04	249.1	3211598.0
2017-09-11 14:30:00	SPY	ETF	249.09	249.18	249.045	249.045	2632788.0
2017-09-11 15:00:00	SPY	ETF	249.045	249.21	249.0201	249.13	3499363.0
2017-09-11 15:30:00	SPY	ETF	249.13	249.19	249.0	249.17	11751130.0
2017-09-11 16:00:00	SPY	ETF	249.17	249.28	246.5251	249.19	10803508.0
2017-09-11 16:30:00	SPY	ETF	249.2	249.35	249.2	249.28	297363.0
2017-09-11 17:00:00	SPY	ETF	249.29	249.29	249.21	249.22	607568.0
2017-09-11 17:30:00	SPY	ETF	249.22	249.27	248.9601	249.27	21362.0
2017-09-11 18:00:00	SPY	ETF	249.28	249.3	249.24	249.29	36867.0
2017-09-11 18:30:00	SPY	ETF	249.28	249.28	249.22	249.24	22076.0
2017-09-11 19:00:00	SPY	ETF	249.24	249.27	249.18	249.18	22584.0
2017-09-11 19:30:00	SPY	ETF	249.23	249.33	249.23	249.31	14301.0
2017-09-11 04:00:00	QQQ	ETF	145.18	145.23	145.17	145.2	6418.0
2017-09-11 04:30:00	QQQ	ETF	145.25	145.39	145.25	145.39	4390.0
2017-09-11 05:30:00	QQQ	ETF	145.36	145.44	145.34	145.41	17051.0
2017-09-11 06:00:00	QQQ	ETF	145.42	145.42	145.4	145.4	2149.0
2017-09-11 06:30:00	QQQ	ETF	145.38	145.41	145.37	145.41	32634.0
2017-09-11 07:00:00	QQQ	ETF	145.39	145.39	145.21	145.3	84620.0
2017-09-11 07:30:00	QQQ	ETF	145.24	145.25	145.19	145.21	68748.0
2017-09-11 08:00:00	QQQ	ETF	145.2	145.27	145.2	145.23	52074.0
2017-09-11 08:30:00	QQQ	ETF	145.25	145.34	145.23	145.34	57825.0
2017-09-11 09:00:00	QQQ	ETF	145.34	145.4	145.3	145.34	101745.0
2017-09-11 09:30:00	QQQ	ETF	145.3	145.99	145.3	145.9	4935407.0
2017-09-11 10:00:00	QQQ	ETF	145.9	146.12	145.9	145.97	2272219.0
2017-09-11 10:30:00	QQQ	ETF	145.96	145.98	145.51	145.56	1513404.0
2017-09-11 11:00:00	QQQ	ETF	145.5561	145.67	145.4	145.515	1134219.0
2017-09-11 11:30:00	QQQ	ETF	145.52	145.7288	145.51	145.69	1167227.0
2017-09-11 12:00:00	QQQ	ETF	145.69	145.82	145.64	145.755	801031.0
2017-09-11 12:30:00	QQQ	ETF	145.76	145.955	145.75	145.89	898810.0
2017-09-11 13:00:00	QQQ	ETF	145.9	145.95	145.81	145.83	937280.0

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

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