PREVIEW / etf_5min / 2012-03-19

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-03-19.parquet
  size:    919 KB
  rows:    37,167

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
2012-03-19 04:00:00	SPY	ETF	140.5	140.5	140.06	140.06	1880.0
2012-03-19 04:10:00	SPY	ETF	140.12	140.15	140.1	140.15	1800.0
2012-03-19 04:20:00	SPY	ETF	140.05	140.05	140.02	140.05	6080.0
2012-03-19 04:25:00	SPY	ETF	140.04	140.04	140.0	140.0	22600.0
2012-03-19 04:30:00	SPY	ETF	139.94	139.94	139.9	139.92	25300.0
2012-03-19 04:35:00	SPY	ETF	139.9	139.9	139.85	139.9	25000.0
2012-03-19 04:55:00	SPY	ETF	139.97	139.97	139.92	139.92	3480.0
2012-03-19 05:30:00	SPY	ETF	140.04	140.04	140.03	140.03	2000.0
2012-03-19 05:35:00	SPY	ETF	140.08	140.08	140.08	140.08	3980.0
2012-03-19 05:40:00	SPY	ETF	140.09	140.09	140.09	140.09	10000.0
2012-03-19 06:05:00	SPY	ETF	140.01	140.01	140.01	140.01	100.0
2012-03-19 06:10:00	SPY	ETF	140.09	140.1	140.04	140.04	14400.0
2012-03-19 06:20:00	SPY	ETF	140.0	140.0	139.97	139.97	1500.0
2012-03-19 06:25:00	SPY	ETF	140.03	140.03	140.03	140.03	500.0
2012-03-19 06:30:00	SPY	ETF	139.96	139.96	139.96	139.96	600.0
2012-03-19 06:55:00	SPY	ETF	140.12	140.12	140.07	140.07	380.0
2012-03-19 07:00:00	SPY	ETF	140.09	140.12	140.02	140.07	21558.0
2012-03-19 07:05:00	SPY	ETF	140.07	140.07	140.02	140.03	10050.0
2012-03-19 07:10:00	SPY	ETF	140.03	140.03	140.02	140.02	2000.0
2012-03-19 07:15:00	SPY	ETF	140.11	140.15	140.1	140.15	11639.0
2012-03-19 07:20:00	SPY	ETF	140.16	140.17	140.16	140.17	331.0
2012-03-19 07:25:00	SPY	ETF	140.15	140.21	140.13	140.18	34161.0
2012-03-19 07:30:00	SPY	ETF	140.16	140.18	140.15	140.18	4601.0
2012-03-19 07:35:00	SPY	ETF	140.19	140.19	140.13	140.13	52911.0
2012-03-19 07:40:00	SPY	ETF	140.16	140.2	140.16	140.18	7400.0
2012-03-19 07:45:00	SPY	ETF	140.18	140.18	140.12	140.13	28100.0
2012-03-19 07:50:00	SPY	ETF	140.12	140.13	140.08	140.12	3300.0
2012-03-19 07:55:00	SPY	ETF	140.12	140.13	140.1	140.13	8800.0
2012-03-19 08:00:00	SPY	ETF	140.15	140.15	140.11	140.15	31286.0
2012-03-19 08:05:00	SPY	ETF	140.15	140.15	140.1	140.1	33112.0
2012-03-19 08:10:00	SPY	ETF	140.11	140.13	140.09	140.09	41470.0
2012-03-19 08:15:00	SPY	ETF	140.09	140.15	140.08	140.15	9700.0
2012-03-19 08:20:00	SPY	ETF	140.12	140.18	140.12	140.18	7900.0
2012-03-19 08:25:00	SPY	ETF	140.16	140.3	140.16	140.17	874012.0
2012-03-19 08:30:00	SPY	ETF	140.18	140.2	139.94	140.01	231898.0
2012-03-19 08:35:00	SPY	ETF	139.99	140.08	139.98	140.06	88170.0
2012-03-19 08:40:00	SPY	ETF	140.03	140.08	140.03	140.07	389682.0
2012-03-19 08:45:00	SPY	ETF	140.05	140.09	140.01	140.07	237674.0
2012-03-19 08:50:00	SPY	ETF	140.06	140.06	139.94	139.95	310150.0
2012-03-19 08:55:00	SPY	ETF	139.95	140.03	139.94	140.03	105438.0
2012-03-19 09:00:00	SPY	ETF	140.03	140.1	140.0	140.05	84290.0
2012-03-19 09:05:00	SPY	ETF	140.05	140.09	140.02	140.08	122534.0
2012-03-19 09:10:00	SPY	ETF	140.08	140.17	140.08	140.16	62452.0
2012-03-19 09:15:00	SPY	ETF	140.16	140.18	140.14	140.16	102332.0
2012-03-19 09:20:00	SPY	ETF	140.16	140.19	140.14	140.18	67674.0
2012-03-19 09:25:00	SPY	ETF	140.18	140.24	140.18	140.24	190293.0
2012-03-19 09:30:00	SPY	ETF	140.21	140.23	140.11	140.16	2807775.0
2012-03-19 09:35:00	SPY	ETF	140.15	140.26	140.15	140.24	3280706.0
2012-03-19 09:40:00	SPY	ETF	140.23	140.32	140.23	140.31	1709023.0
2012-03-19 09:45:00	SPY	ETF	140.31	140.59	140.26	140.59	3243189.0

> showing 50 of 37,167 rows — these rows as CSV

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