PREVIEW / etf_5min / 2013-01-07

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-07.parquet
  size:    919 KB
  rows:    40,538

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
2013-01-07 04:00:00	SPY	ETF	146.03	146.03	145.9	145.94	2900.0
2013-01-07 04:45:00	SPY	ETF	146.01	146.01	146.01	146.01	2600.0
2013-01-07 04:55:00	SPY	ETF	145.92	145.92	145.92	145.92	1108.0
2013-01-07 05:00:00	SPY	ETF	145.94	145.94	145.94	145.94	100.0
2013-01-07 05:30:00	SPY	ETF	145.96	145.96	145.96	145.96	200.0
2013-01-07 05:40:00	SPY	ETF	145.96	145.96	145.95	145.95	10300.0
2013-01-07 05:45:00	SPY	ETF	145.96	145.96	145.96	145.96	9000.0
2013-01-07 05:55:00	SPY	ETF	145.96	145.96	145.96	145.96	8950.0
2013-01-07 06:00:00	SPY	ETF	145.96	145.96	145.96	145.96	200.0
2013-01-07 06:05:00	SPY	ETF	145.97	145.97	145.96	145.96	5300.0
2013-01-07 06:10:00	SPY	ETF	145.96	145.96	145.92	145.96	8250.0
2013-01-07 06:15:00	SPY	ETF	145.98	145.98	145.96	145.96	4700.0
2013-01-07 06:25:00	SPY	ETF	145.96	145.96	145.92	145.92	21500.0
2013-01-07 06:30:00	SPY	ETF	145.91	145.91	145.87	145.88	98799.0
2013-01-07 06:35:00	SPY	ETF	145.88	145.89	145.88	145.89	49550.0
2013-01-07 06:45:00	SPY	ETF	145.88	145.91	145.88	145.91	3100.0
2013-01-07 06:50:00	SPY	ETF	145.88	145.9	145.88	145.9	7400.0
2013-01-07 06:55:00	SPY	ETF	145.88	145.91	145.88	145.91	5400.0
2013-01-07 07:00:00	SPY	ETF	145.88	146.01	145.88	146.01	6094.0
2013-01-07 07:05:00	SPY	ETF	145.98	145.99	145.95	145.99	5081.0
2013-01-07 07:10:00	SPY	ETF	145.99	146.0	145.96	145.96	4250.0
2013-01-07 07:15:00	SPY	ETF	145.99	145.99	145.97	145.97	1544.0
2013-01-07 07:20:00	SPY	ETF	145.97	146.0	145.92	145.92	4350.0
2013-01-07 07:25:00	SPY	ETF	145.96	146.04	145.96	146.0	5400.0
2013-01-07 07:30:00	SPY	ETF	145.99	146.01	145.98	145.99	22200.0
2013-01-07 07:35:00	SPY	ETF	145.99	146.04	145.99	146.0	1400.0
2013-01-07 07:40:00	SPY	ETF	145.99	146.04	145.95	145.95	106400.0
2013-01-07 07:45:00	SPY	ETF	145.95	145.98	145.93	145.95	41640.0
2013-01-07 07:50:00	SPY	ETF	145.94	145.95	145.92	145.95	3900.0
2013-01-07 07:55:00	SPY	ETF	145.95	145.97	145.93	145.96	13000.0
2013-01-07 08:00:00	SPY	ETF	145.99	145.99	145.94	145.94	127900.0
2013-01-07 08:05:00	SPY	ETF	145.94	145.94	145.93	145.93	25720.0
2013-01-07 08:10:00	SPY	ETF	145.93	145.99	145.92	145.98	41280.0
2013-01-07 08:15:00	SPY	ETF	145.99	146.02	145.99	146.01	24485.0
2013-01-07 08:20:00	SPY	ETF	145.99	145.99	145.93	145.95	28963.0
2013-01-07 08:25:00	SPY	ETF	145.99	146.02	145.96	145.96	5160.0
2013-01-07 08:30:00	SPY	ETF	145.96	145.96	145.9	145.91	11855.0
2013-01-07 08:35:00	SPY	ETF	145.92	145.93	145.87	145.91	16565.0
2013-01-07 08:40:00	SPY	ETF	145.91	145.91	145.85	145.88	35100.0
2013-01-07 08:45:00	SPY	ETF	145.88	145.88	145.83	145.87	19200.0
2013-01-07 08:50:00	SPY	ETF	145.87	145.88	145.86	145.86	6700.0
2013-01-07 08:55:00	SPY	ETF	145.88	145.99	145.85	145.85	120415.0
2013-01-07 09:00:00	SPY	ETF	145.85	145.88	145.81	145.83	75668.0
2013-01-07 09:05:00	SPY	ETF	145.83	145.86	145.83	145.86	43585.0
2013-01-07 09:10:00	SPY	ETF	145.86	145.87	145.83	145.85	534007.0
2013-01-07 09:15:00	SPY	ETF	145.85	145.85	145.76	145.78	143008.0
2013-01-07 09:20:00	SPY	ETF	145.78	145.83	145.77	145.83	315516.0
2013-01-07 09:25:00	SPY	ETF	145.82	145.86	145.8	145.86	86965.0
2013-01-07 09:30:00	SPY	ETF	145.85	145.89	145.66	145.72	3180690.0
2013-01-07 09:35:00	SPY	ETF	145.72	145.81	145.64	145.65	1866788.0

> showing 50 of 40,538 rows — these rows as CSV

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