PREVIEW / etf_5min / 2014-01-22

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-01-22.parquet
  size:    1.0 MB
  rows:    44,405

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-01-22 04:00:00	SPY	ETF	184.3	184.33	184.3	184.33	967.0
2014-01-22 04:05:00	SPY	ETF	184.33	184.33	184.33	184.33	314.0
2014-01-22 04:15:00	SPY	ETF	184.31	184.31	184.31	184.31	1500.0
2014-01-22 04:55:00	SPY	ETF	184.16	184.16	184.16	184.16	2000.0
2014-01-22 05:15:00	SPY	ETF	184.21	184.21	184.21	184.21	1058.0
2014-01-22 05:20:00	SPY	ETF	184.21	184.21	184.16	184.16	2669.0
2014-01-22 05:25:00	SPY	ETF	184.13	184.13	184.11	184.11	3054.0
2014-01-22 05:30:00	SPY	ETF	184.11	184.11	184.08	184.08	5600.0
2014-01-22 05:35:00	SPY	ETF	184.11	184.11	184.09	184.09	1080.0
2014-01-22 05:40:00	SPY	ETF	184.07	184.07	183.98	184.0	5639.0
2014-01-22 05:45:00	SPY	ETF	183.97	184.02	183.97	183.98	851.0
2014-01-22 05:50:00	SPY	ETF	184.01	184.01	184.01	184.01	1300.0
2014-01-22 06:00:00	SPY	ETF	183.92	183.92	183.9	183.92	500.0
2014-01-22 06:10:00	SPY	ETF	184.01	184.01	184.01	184.01	198.0
2014-01-22 06:20:00	SPY	ETF	183.95	183.97	183.95	183.97	262.0
2014-01-22 06:25:00	SPY	ETF	184.01	184.01	184.01	184.01	3500.0
2014-01-22 06:30:00	SPY	ETF	184.07	184.07	184.07	184.07	113.0
2014-01-22 06:35:00	SPY	ETF	184.1	184.1	184.08	184.08	1100.0
2014-01-22 06:55:00	SPY	ETF	184.06	184.06	184.06	184.06	100.0
2014-01-22 07:00:00	SPY	ETF	184.14	184.15	184.08	184.08	6000.0
2014-01-22 07:05:00	SPY	ETF	184.13	184.14	184.13	184.14	750.0
2014-01-22 07:10:00	SPY	ETF	184.1	184.1	184.06	184.07	11358.0
2014-01-22 07:15:00	SPY	ETF	184.08	184.1	184.06	184.1	4787.0
2014-01-22 07:20:00	SPY	ETF	184.11	184.15	184.11	184.15	3000.0
2014-01-22 07:25:00	SPY	ETF	184.14	184.2	184.14	184.2	6174.0
2014-01-22 07:35:00	SPY	ETF	184.19	184.19	184.13	184.15	3484.0
2014-01-22 07:40:00	SPY	ETF	184.13	184.15	184.13	184.15	6800.0
2014-01-22 07:45:00	SPY	ETF	184.17	184.17	184.17	184.17	475.0
2014-01-22 07:50:00	SPY	ETF	184.11	184.11	184.04	184.04	8284.0
2014-01-22 07:55:00	SPY	ETF	184.035	184.06	184.01	184.04	78424.0
2014-01-22 08:00:00	SPY	ETF	184.06	184.07	184.01	184.01	46679.0
2014-01-22 08:05:00	SPY	ETF	183.99	184.05	183.99	184.05	3942.0
2014-01-22 08:10:00	SPY	ETF	184.04	184.06	184.03	184.05	4800.0
2014-01-22 08:15:00	SPY	ETF	184.04	184.07	184.02	184.02	14397.0
2014-01-22 08:20:00	SPY	ETF	184.05	184.1	184.04	184.1	7913.0
2014-01-22 08:25:00	SPY	ETF	184.1	184.11	184.1	184.11	15297.0
2014-01-22 08:30:00	SPY	ETF	184.11	184.12	184.1	184.12	15749.0
2014-01-22 08:35:00	SPY	ETF	184.1	184.14	184.1	184.14	2260.0
2014-01-22 08:40:00	SPY	ETF	184.14	184.18	184.13	184.18	16748.0
2014-01-22 08:45:00	SPY	ETF	184.18	184.22	184.16	184.2	62284.0
2014-01-22 08:50:00	SPY	ETF	184.2	184.36	184.2	184.34	65900.0
2014-01-22 08:55:00	SPY	ETF	184.34	184.35	184.29	184.29	20461.0
2014-01-22 09:00:00	SPY	ETF	184.3	184.33	184.3	184.33	28738.0
2014-01-22 09:05:00	SPY	ETF	184.33	184.37	184.32	184.32	38689.0
2014-01-22 09:10:00	SPY	ETF	184.32	184.33	184.31	184.31	25048.0
2014-01-22 09:15:00	SPY	ETF	184.32	184.4	184.29	184.39	206028.0
2014-01-22 09:20:00	SPY	ETF	184.4	184.54	184.4	184.51	141113.0
2014-01-22 09:25:00	SPY	ETF	184.5	184.6	184.49	184.5	205963.0
2014-01-22 09:30:00	SPY	ETF	184.49	184.52	184.36	184.4301	2263535.0
2014-01-22 09:35:00	SPY	ETF	184.44	184.51	184.34	184.36	1124813.0

> showing 50 of 44,405 rows — these rows as CSV

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