PREVIEW / etf_5min / 2014-10-17

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-17.parquet
  size:    1.1 MB
  rows:    49,397

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
2014-10-17 04:00:00	SPY	ETF	187.0	187.31	187.0	187.3	4147.0
2014-10-17 04:05:00	SPY	ETF	187.41	187.6	187.41	187.6	829.0
2014-10-17 04:10:00	SPY	ETF	187.75	187.75	187.53	187.58	478.0
2014-10-17 04:15:00	SPY	ETF	187.52	187.95	187.3	187.4	30946.0
2014-10-17 04:20:00	SPY	ETF	187.7	188.0	187.7	187.86	735.0
2014-10-17 04:25:00	SPY	ETF	187.68	187.68	187.68	187.68	110.0
2014-10-17 04:30:00	SPY	ETF	187.7	187.72	187.7	187.72	400.0
2014-10-17 04:35:00	SPY	ETF	187.65	187.84	187.65	187.84	300.0
2014-10-17 04:40:00	SPY	ETF	187.92	187.92	187.92	187.92	150.0
2014-10-17 04:45:00	SPY	ETF	187.89	188.19	187.85	188.19	1090.0
2014-10-17 04:55:00	SPY	ETF	187.93	188.0	187.93	188.0	2602.0
2014-10-17 05:05:00	SPY	ETF	188.09	188.2	188.09	188.2	3600.0
2014-10-17 05:10:00	SPY	ETF	188.03	188.03	187.95	187.95	500.0
2014-10-17 05:15:00	SPY	ETF	188.0	188.0	187.82	187.9	3500.0
2014-10-17 05:20:00	SPY	ETF	187.94	188.13	187.94	188.13	23350.0
2014-10-17 05:25:00	SPY	ETF	188.08	188.15	188.08	188.1	7915.0
2014-10-17 05:30:00	SPY	ETF	188.11	188.11	188.08	188.08	1245.0
2014-10-17 05:35:00	SPY	ETF	188.08	188.08	187.93	188.02	24800.0
2014-10-17 05:40:00	SPY	ETF	188.06	188.12	187.92	187.92	11425.0
2014-10-17 05:45:00	SPY	ETF	188.05	188.06	187.95	187.99	9274.0
2014-10-17 05:50:00	SPY	ETF	188.0	188.0	188.0	188.0	3750.0
2014-10-17 05:55:00	SPY	ETF	187.98	187.98	187.9	187.98	795.0
2014-10-17 06:00:00	SPY	ETF	188.0	188.13	188.0	188.05	2591.0
2014-10-17 06:05:00	SPY	ETF	188.05	188.08	188.05	188.06	1800.0
2014-10-17 06:10:00	SPY	ETF	188.1	188.22	188.1	188.19	10410.0
2014-10-17 06:15:00	SPY	ETF	188.08	188.43	188.08	188.43	11588.0
2014-10-17 06:20:00	SPY	ETF	188.39	188.42	188.33	188.33	10326.0
2014-10-17 06:25:00	SPY	ETF	188.34	188.37	188.3	188.3	1875.0
2014-10-17 06:30:00	SPY	ETF	188.15	188.22	188.1	188.1	11901.0
2014-10-17 06:35:00	SPY	ETF	188.11	188.11	187.97	188.0	17999.0
2014-10-17 06:40:00	SPY	ETF	188.01	188.1	188.0	188.07	13798.0
2014-10-17 06:45:00	SPY	ETF	188.0	188.03	187.9	187.97	87346.0
2014-10-17 06:50:00	SPY	ETF	188.0	188.05	187.97	188.04	146850.0
2014-10-17 06:55:00	SPY	ETF	188.01	188.03	187.82	187.82	88875.0
2014-10-17 07:00:00	SPY	ETF	187.8	187.97	187.8	187.91	77241.0
2014-10-17 07:05:00	SPY	ETF	187.84	187.84	187.75	187.78	81052.0
2014-10-17 07:10:00	SPY	ETF	187.8	187.94	187.79	187.9	146042.0
2014-10-17 07:15:00	SPY	ETF	187.95	188.12	187.95	188.12	62788.0
2014-10-17 07:20:00	SPY	ETF	188.07	188.17	188.07	188.15	8861.0
2014-10-17 07:25:00	SPY	ETF	188.16	188.34	188.16	188.34	215085.0
2014-10-17 07:30:00	SPY	ETF	188.34	188.37	188.2	188.27	51449.0
2014-10-17 07:35:00	SPY	ETF	188.2	188.25	188.14	188.23	87564.0
2014-10-17 07:40:00	SPY	ETF	188.23	188.32	188.18	188.23	82837.0
2014-10-17 07:45:00	SPY	ETF	188.2	188.21	188.12	188.15	125274.0
2014-10-17 07:50:00	SPY	ETF	188.15	188.29	188.13	188.28	125291.0
2014-10-17 07:55:00	SPY	ETF	188.26	188.3	188.08	188.09	36834.0
2014-10-17 08:00:00	SPY	ETF	188.08	188.21	187.78	187.82	299292.0
2014-10-17 08:05:00	SPY	ETF	187.82	188.03	187.82	187.92	130150.0
2014-10-17 08:10:00	SPY	ETF	187.91	187.93	187.69	187.7	115383.0
2014-10-17 08:15:00	SPY	ETF	187.72	187.84	187.69	187.74	93275.0

> showing 50 of 49,397 rows — these rows as CSV

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