PREVIEW / etf_5min / 2012-09-26

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-26.parquet
  size:    894 KB
  rows:    37,467

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-09-26 05:05:00	SPY	ETF	144.31	144.31	144.31	144.31	100.0
2012-09-26 05:20:00	SPY	ETF	144.38	144.38	144.38	144.38	500.0
2012-09-26 05:30:00	SPY	ETF	144.43	144.43	144.43	144.43	500.0
2012-09-26 05:35:00	SPY	ETF	144.38	144.38	144.38	144.38	200.0
2012-09-26 05:45:00	SPY	ETF	144.31	144.31	144.3	144.3	300.0
2012-09-26 06:05:00	SPY	ETF	144.17	144.22	144.17	144.22	3500.0
2012-09-26 06:10:00	SPY	ETF	144.2	144.2	144.2	144.2	800.0
2012-09-26 06:15:00	SPY	ETF	144.29	144.29	144.29	144.29	500.0
2012-09-26 06:20:00	SPY	ETF	144.27	144.27	144.27	144.27	100.0
2012-09-26 06:25:00	SPY	ETF	144.17	144.17	144.17	144.17	250.0
2012-09-26 06:30:00	SPY	ETF	144.15	144.15	144.15	144.15	500.0
2012-09-26 06:35:00	SPY	ETF	144.18	144.18	144.18	144.18	100.0
2012-09-26 06:40:00	SPY	ETF	144.21	144.21	144.21	144.21	1000.0
2012-09-26 06:50:00	SPY	ETF	144.21	144.21	144.21	144.21	500.0
2012-09-26 06:55:00	SPY	ETF	144.17	144.17	144.17	144.17	150.0
2012-09-26 07:00:00	SPY	ETF	144.2	144.2	144.19	144.19	1000.0
2012-09-26 07:05:00	SPY	ETF	144.18	144.2	144.16	144.2	11100.0
2012-09-26 07:10:00	SPY	ETF	144.2	144.2	144.19	144.2	26000.0
2012-09-26 07:15:00	SPY	ETF	144.2	144.23	144.2	144.23	9148.0
2012-09-26 07:20:00	SPY	ETF	144.22	144.22	144.15	144.15	17499.0
2012-09-26 07:25:00	SPY	ETF	144.15	144.15	144.11	144.11	813.0
2012-09-26 07:30:00	SPY	ETF	144.1	144.11	144.0	144.04	42908.0
2012-09-26 07:35:00	SPY	ETF	144.04	144.06	143.95	143.95	75166.0
2012-09-26 07:40:00	SPY	ETF	143.95	143.99	143.95	143.99	46400.0
2012-09-26 07:45:00	SPY	ETF	143.95	143.99	143.93	143.99	93820.0
2012-09-26 07:50:00	SPY	ETF	144.0	144.02	143.97	143.99	21000.0
2012-09-26 07:55:00	SPY	ETF	144.0	144.12	144.0	144.12	206488.0
2012-09-26 08:00:00	SPY	ETF	144.11	144.13	144.03	144.03	48720.0
2012-09-26 08:05:00	SPY	ETF	144.05	144.05	143.98	143.98	27552.0
2012-09-26 08:10:00	SPY	ETF	144.0	144.01	143.92	143.92	130421.0
2012-09-26 08:15:00	SPY	ETF	143.93	143.97	143.9	143.93	102680.0
2012-09-26 08:20:00	SPY	ETF	143.91	144.0545	143.83	143.85	230590.0
2012-09-26 08:25:00	SPY	ETF	143.86	143.92	143.8	143.91	303491.0
2012-09-26 08:30:00	SPY	ETF	143.92	143.92	143.86	143.86	32630.0
2012-09-26 08:35:00	SPY	ETF	143.89	143.93	143.87	143.87	46980.0
2012-09-26 08:40:00	SPY	ETF	143.88	143.93	143.8	143.91	48676.0
2012-09-26 08:45:00	SPY	ETF	143.9	143.96	143.9	143.94	76996.0
2012-09-26 08:50:00	SPY	ETF	143.95	144.06	143.95	144.03	116784.0
2012-09-26 08:55:00	SPY	ETF	144.03	144.05	144.01	144.01	41168.0
2012-09-26 09:00:00	SPY	ETF	144.01	144.19	144.01	144.19	22950.0
2012-09-26 09:05:00	SPY	ETF	144.05	144.05	144.0	144.0	53402.0
2012-09-26 09:10:00	SPY	ETF	144.0	144.01	143.97	143.98	66420.0
2012-09-26 09:15:00	SPY	ETF	143.97	144.04	143.97	144.02	192783.0
2012-09-26 09:20:00	SPY	ETF	144.02	144.06	144.0	144.04	193906.0
2012-09-26 09:25:00	SPY	ETF	144.04	144.07	144.0	144.06	236424.0
2012-09-26 09:30:00	SPY	ETF	144.065	144.11	143.97	144.05	3601843.0
2012-09-26 09:35:00	SPY	ETF	144.05	144.07	143.83	143.83	3458912.0
2012-09-26 09:40:00	SPY	ETF	143.83	143.85	143.67	143.76	3577832.0
2012-09-26 09:45:00	SPY	ETF	143.7601	143.79	143.56	143.62	2874265.0
2012-09-26 09:50:00	SPY	ETF	143.6117	143.78	143.6	143.77	2187452.0

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

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