PREVIEW / etf_5min / 2017-06-28

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-28.parquet
  size:    1.2 MB
  rows:    52,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-06-28 04:00:00	SPY	ETF	241.32	241.37	241.32	241.33	12150.0
2017-06-28 04:05:00	SPY	ETF	241.37	241.37	241.22	241.22	2380.0
2017-06-28 04:10:00	SPY	ETF	241.25	241.28	241.2	241.2	3500.0
2017-06-28 04:15:00	SPY	ETF	241.22	241.22	241.15	241.15	2470.0
2017-06-28 04:25:00	SPY	ETF	241.21	241.21	241.21	241.21	200.0
2017-06-28 04:40:00	SPY	ETF	241.35	241.38	241.35	241.38	1100.0
2017-06-28 04:45:00	SPY	ETF	241.43	241.43	241.43	241.43	500.0
2017-06-28 04:50:00	SPY	ETF	241.48	241.48	241.41	241.47	800.0
2017-06-28 04:55:00	SPY	ETF	241.48	241.48	241.44	241.45	1200.0
2017-06-28 05:00:00	SPY	ETF	241.48	241.5	241.48	241.48	700.0
2017-06-28 05:15:00	SPY	ETF	241.59	241.59	241.59	241.59	12300.0
2017-06-28 05:20:00	SPY	ETF	241.58	241.58	241.58	241.58	11900.0
2017-06-28 05:25:00	SPY	ETF	241.58	241.58	241.58	241.58	500.0
2017-06-28 05:30:00	SPY	ETF	241.58	241.64	241.58	241.64	3070.0
2017-06-28 05:40:00	SPY	ETF	241.64	241.84	241.64	241.84	6168.0
2017-06-28 05:55:00	SPY	ETF	241.82	241.82	241.82	241.82	200.0
2017-06-28 06:05:00	SPY	ETF	241.87	241.87	241.87	241.87	130.0
2017-06-28 06:10:00	SPY	ETF	241.99	242.04	241.99	242.04	4039.0
2017-06-28 06:15:00	SPY	ETF	241.93	241.93	241.93	241.93	1000.0
2017-06-28 06:25:00	SPY	ETF	241.96	241.99	241.95	241.95	10200.0
2017-06-28 06:30:00	SPY	ETF	241.92	242.02	241.92	242.02	2050.0
2017-06-28 06:35:00	SPY	ETF	241.94	241.96	241.93	241.93	14819.0
2017-06-28 06:40:00	SPY	ETF	241.9	241.9	241.9	241.9	24700.0
2017-06-28 06:45:00	SPY	ETF	241.9	241.9	241.9	241.9	5500.0
2017-06-28 06:50:00	SPY	ETF	241.92	241.92	241.9	241.9	1105.0
2017-06-28 06:55:00	SPY	ETF	241.9	241.93	241.89	241.9	4045.0
2017-06-28 07:00:00	SPY	ETF	241.9	241.93	241.86	241.86	7150.0
2017-06-28 07:05:00	SPY	ETF	241.87	241.87	241.83	241.86	13391.0
2017-06-28 07:10:00	SPY	ETF	241.85	241.89	241.83	241.89	8294.0
2017-06-28 07:15:00	SPY	ETF	241.87	241.87	241.86	241.86	51619.0
2017-06-28 07:20:00	SPY	ETF	241.9	241.94	241.89	241.89	54000.0
2017-06-28 07:25:00	SPY	ETF	241.88	242.02	241.88	242.02	6904.0
2017-06-28 07:30:00	SPY	ETF	241.95	242.0	241.95	242.0	1929.0
2017-06-28 07:35:00	SPY	ETF	241.97	242.04	241.97	242.04	16410.0
2017-06-28 07:40:00	SPY	ETF	242.05	242.05	241.98	242.01	12403.0
2017-06-28 07:45:00	SPY	ETF	242.0	242.04	241.99	242.0	32802.0
2017-06-28 07:50:00	SPY	ETF	242.0	242.1	242.0	242.07	164219.0
2017-06-28 07:55:00	SPY	ETF	242.05	242.1	242.04	242.05	81990.0
2017-06-28 08:00:00	SPY	ETF	242.05	242.08	242.02	242.06	7058.0
2017-06-28 08:05:00	SPY	ETF	242.05	242.08	242.02	242.07	9172.0
2017-06-28 08:10:00	SPY	ETF	242.05	242.05	241.97	241.97	13944.0
2017-06-28 08:15:00	SPY	ETF	241.98	242.57	241.95	242.49	470674.0
2017-06-28 08:20:00	SPY	ETF	242.46	242.47	242.3	242.32	213420.0
2017-06-28 08:25:00	SPY	ETF	242.32	242.46	242.3	242.4	199528.0
2017-06-28 08:30:00	SPY	ETF	242.39	242.41	242.28	242.28	47454.0
2017-06-28 08:35:00	SPY	ETF	242.28	242.33	242.22	242.28	51552.0
2017-06-28 08:40:00	SPY	ETF	242.27	242.38	242.27	242.38	52967.0
2017-06-28 08:45:00	SPY	ETF	242.4	242.41	242.37	242.37	78746.0
2017-06-28 08:50:00	SPY	ETF	242.38	242.41	242.35	242.35	9867.0
2017-06-28 08:55:00	SPY	ETF	242.35	242.39	242.32	242.35	112566.0

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

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