PREVIEW / etf_30min / 2017-09-29

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-29.parquet
  size:    432 KB
  rows:    14,947

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-29 04:00:00	SPY	ETF	250.23	250.32	250.23	250.29	7000.0
2017-09-29 04:30:00	SPY	ETF	250.29	250.31	250.24	250.24	15550.0
2017-09-29 05:00:00	SPY	ETF	250.29	250.3	250.24	250.24	2200.0
2017-09-29 05:30:00	SPY	ETF	250.24	250.29	250.24	250.29	6200.0
2017-09-29 06:00:00	SPY	ETF	250.29	250.34	250.29	250.34	8809.0
2017-09-29 06:30:00	SPY	ETF	250.35	250.36	250.35	250.36	8970.0
2017-09-29 07:00:00	SPY	ETF	250.34	250.34	250.29	250.29	19331.0
2017-09-29 07:30:00	SPY	ETF	250.28	250.29	250.23	250.28	85049.0
2017-09-29 08:00:00	SPY	ETF	250.35	250.35	250.25	250.29	26791.0
2017-09-29 08:30:00	SPY	ETF	250.31	250.33	250.16	250.22	77472.0
2017-09-29 09:00:00	SPY	ETF	250.23	250.35	250.18	250.34	644269.0
2017-09-29 09:30:00	SPY	ETF	250.34	250.56	250.13	250.3	4223186.0
2017-09-29 10:00:00	SPY	ETF	250.31	250.53	250.29	250.4857	2500710.0
2017-09-29 10:30:00	SPY	ETF	250.49	250.79	250.48	250.74	3078567.0
2017-09-29 11:00:00	SPY	ETF	250.74	250.935	250.67	250.82	4565717.0
2017-09-29 11:30:00	SPY	ETF	250.82	251.0	250.77	250.99	2772786.0
2017-09-29 12:00:00	SPY	ETF	250.99	251.15	250.95	251.145	1889337.0
2017-09-29 12:30:00	SPY	ETF	251.15	251.16	251.03	251.09	1454098.0
2017-09-29 13:00:00	SPY	ETF	251.095	251.12	251.0	251.06	1361038.0
2017-09-29 13:30:00	SPY	ETF	251.06	251.1101	250.96	251.04	3459863.0
2017-09-29 14:00:00	SPY	ETF	251.046	251.07	250.88	251.06	6464991.0
2017-09-29 14:30:00	SPY	ETF	251.055	251.09	250.88	251.02	3164250.0
2017-09-29 15:00:00	SPY	ETF	251.01	251.13	250.97	251.0003	4068430.0
2017-09-29 15:30:00	SPY	ETF	251.01	251.32	250.98	251.2	17656391.0
2017-09-29 16:00:00	SPY	ETF	251.21	251.39	251.12	251.37	22456440.0
2017-09-29 16:30:00	SPY	ETF	251.39	251.42	250.8323	251.4	1867994.0
2017-09-29 17:00:00	SPY	ETF	251.39	251.47	251.23	251.42	171100.0
2017-09-29 17:30:00	SPY	ETF	251.42	251.45	251.24	251.25	248521.0
2017-09-29 18:00:00	SPY	ETF	251.25	251.33	251.24	251.26	76082.0
2017-09-29 18:30:00	SPY	ETF	251.3	251.39	251.3	251.38	16256.0
2017-09-29 19:00:00	SPY	ETF	251.35	251.4	251.33	251.35	13337.0
2017-09-29 19:30:00	SPY	ETF	251.35	251.44	251.35	251.44	26139.0
2017-09-29 04:00:00	QQQ	ETF	144.5	144.5	144.5	144.5	200.0
2017-09-29 04:30:00	QQQ	ETF	144.56	144.56	144.56	144.56	3100.0
2017-09-29 05:00:00	QQQ	ETF	144.55	144.58	144.55	144.58	1600.0
2017-09-29 05:30:00	QQQ	ETF	144.56	144.58	144.56	144.58	1000.0
2017-09-29 06:00:00	QQQ	ETF	144.65	144.65	144.65	144.65	200.0
2017-09-29 07:00:00	QQQ	ETF	144.66	144.69	144.64	144.65	93797.0
2017-09-29 07:30:00	QQQ	ETF	144.67	144.68	144.63	144.65	42899.0
2017-09-29 08:00:00	QQQ	ETF	144.69	144.69	144.64	144.64	66512.0
2017-09-29 08:30:00	QQQ	ETF	144.66	144.67	144.59	144.6	34920.0
2017-09-29 09:00:00	QQQ	ETF	144.61	144.72	144.61	144.69	58091.0
2017-09-29 09:30:00	QQQ	ETF	144.7	144.91	144.39	144.3907	3368958.0
2017-09-29 10:00:00	QQQ	ETF	144.4	144.8	144.32	144.7	1844443.0
2017-09-29 10:30:00	QQQ	ETF	144.71	144.98	144.64	144.875	2266972.0
2017-09-29 11:00:00	QQQ	ETF	144.87	145.32	144.82	145.2134	2988882.0
2017-09-29 11:30:00	QQQ	ETF	145.21	145.29	145.0766	145.29	1277858.0
2017-09-29 12:00:00	QQQ	ETF	145.29	145.43	145.21	145.41	1963131.0
2017-09-29 12:30:00	QQQ	ETF	145.4	145.55	145.36	145.5234	1968103.0
2017-09-29 13:00:00	QQQ	ETF	145.525	145.555	145.39	145.42	1478989.0

> showing 50 of 14,947 rows — these rows as CSV

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