PREVIEW / etf_5min / 2012-04-09

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-09.parquet
  size:    863 KB
  rows:    36,849

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-04-09 04:00:00	SPY	ETF	138.23	138.42	138.22	138.32	3603.0
2012-04-09 04:05:00	SPY	ETF	138.37	138.37	138.3	138.3	1500.0
2012-04-09 04:10:00	SPY	ETF	138.4	138.4	138.4	138.4	470.0
2012-04-09 04:15:00	SPY	ETF	138.4	138.4	138.32	138.32	213.0
2012-04-09 04:20:00	SPY	ETF	138.3	138.35	138.15	138.35	700.0
2012-04-09 04:40:00	SPY	ETF	138.25	138.25	138.25	138.25	100.0
2012-04-09 04:45:00	SPY	ETF	138.22	138.22	138.22	138.22	182.0
2012-04-09 04:55:00	SPY	ETF	138.22	138.22	138.16	138.16	500.0
2012-04-09 05:00:00	SPY	ETF	138.2	138.2	138.2	138.2	100.0
2012-04-09 05:10:00	SPY	ETF	138.35	138.35	138.35	138.35	100.0
2012-04-09 05:20:00	SPY	ETF	138.35	138.35	138.35	138.35	100.0
2012-04-09 05:35:00	SPY	ETF	138.22	138.27	138.22	138.23	8300.0
2012-04-09 05:40:00	SPY	ETF	138.23	138.25	138.2	138.2	53988.0
2012-04-09 05:45:00	SPY	ETF	138.2	138.2	138.02	138.02	3500.0
2012-04-09 05:55:00	SPY	ETF	138.04	138.04	138.04	138.04	6500.0
2012-04-09 06:00:00	SPY	ETF	138.03	138.03	138.0	138.03	21545.0
2012-04-09 06:05:00	SPY	ETF	138.07	138.07	138.07	138.07	129.0
2012-04-09 06:10:00	SPY	ETF	138.03	138.03	137.97	137.97	6060.0
2012-04-09 06:15:00	SPY	ETF	137.97	138.02	137.97	138.0	10600.0
2012-04-09 06:20:00	SPY	ETF	138.02	138.02	138.02	138.02	1000.0
2012-04-09 06:25:00	SPY	ETF	138.07	138.07	138.07	138.07	50000.0
2012-04-09 06:30:00	SPY	ETF	138.03	138.03	138.03	138.03	1000.0
2012-04-09 06:35:00	SPY	ETF	138.0	138.07	138.0	138.07	1770.0
2012-04-09 06:40:00	SPY	ETF	138.02	138.02	138.02	138.02	300.0
2012-04-09 06:45:00	SPY	ETF	138.0	138.0	137.97	137.98	9000.0
2012-04-09 06:50:00	SPY	ETF	137.97	137.99	137.97	137.99	500.0
2012-04-09 06:55:00	SPY	ETF	138.0	138.0	138.0	138.0	8000.0
2012-04-09 07:00:00	SPY	ETF	138.02	138.03	138.01	138.03	39406.0
2012-04-09 07:05:00	SPY	ETF	138.03	138.05	138.03	138.04	7215.0
2012-04-09 07:10:00	SPY	ETF	138.09	138.17	138.09	138.17	35387.0
2012-04-09 07:15:00	SPY	ETF	138.17	138.17	138.13	138.16	4334.0
2012-04-09 07:20:00	SPY	ETF	138.16	138.19	138.1	138.11	13608.0
2012-04-09 07:25:00	SPY	ETF	138.15	138.16	138.15	138.16	800.0
2012-04-09 07:30:00	SPY	ETF	138.18	138.19	138.14	138.16	19873.0
2012-04-09 07:35:00	SPY	ETF	138.13	138.13	138.08	138.08	13506.0
2012-04-09 07:40:00	SPY	ETF	138.08	138.13	138.08	138.13	8662.0
2012-04-09 07:45:00	SPY	ETF	138.13	138.18	138.09	138.1	43040.0
2012-04-09 07:50:00	SPY	ETF	138.11	138.11	137.96	137.98	38908.0
2012-04-09 07:55:00	SPY	ETF	138.0	138.02	137.98	138.02	31749.0
2012-04-09 08:00:00	SPY	ETF	138.03	138.23	137.98	138.01	74893.0
2012-04-09 08:05:00	SPY	ETF	138.02	138.04	137.98	138.04	11920.0
2012-04-09 08:10:00	SPY	ETF	138.04	138.05	137.97	137.98	56908.0
2012-04-09 08:15:00	SPY	ETF	137.98	138.04	137.97	138.04	33800.0
2012-04-09 08:20:00	SPY	ETF	138.02	138.04	137.97	137.99	76066.0
2012-04-09 08:25:00	SPY	ETF	137.99	138.01	137.98	137.99	50939.0
2012-04-09 08:30:00	SPY	ETF	138.0	138.06	137.99	138.04	29296.0
2012-04-09 08:35:00	SPY	ETF	138.05	138.14	137.94	138.05	74143.0
2012-04-09 08:40:00	SPY	ETF	138.05	138.09	138.03	138.05	49884.0
2012-04-09 08:45:00	SPY	ETF	138.06	139.79	137.98	137.99	39597.0
2012-04-09 08:50:00	SPY	ETF	138.0	138.04	137.99	138.0	98557.0

> showing 50 of 36,849 rows — these rows as CSV

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