PREVIEW / etf_5min / 2013-01-25

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-25.parquet
  size:    980 KB
  rows:    41,647

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-25 04:00:00	SPY	ETF	149.66	149.83	149.66	149.83	2250.0
2013-01-25 04:05:00	SPY	ETF	149.84	149.84	149.84	149.84	800.0
2013-01-25 04:15:00	SPY	ETF	149.85	149.85	149.85	149.85	200.0
2013-01-25 04:25:00	SPY	ETF	149.84	149.84	149.84	149.84	200.0
2013-01-25 04:45:00	SPY	ETF	149.86	149.86	149.86	149.86	10088.0
2013-01-25 04:50:00	SPY	ETF	149.84	149.87	149.84	149.87	600.0
2013-01-25 05:00:00	SPY	ETF	149.87	149.88	149.87	149.88	16000.0
2013-01-25 05:10:00	SPY	ETF	149.89	149.89	149.89	149.89	500.0
2013-01-25 05:15:00	SPY	ETF	149.9	149.91	149.9	149.91	6425.0
2013-01-25 05:20:00	SPY	ETF	149.97	149.97	149.97	149.97	2000.0
2013-01-25 05:25:00	SPY	ETF	149.95	149.96	149.91	149.91	5500.0
2013-01-25 05:30:00	SPY	ETF	149.91	149.91	149.91	149.91	600.0
2013-01-25 05:35:00	SPY	ETF	149.91	149.94	149.91	149.91	20300.0
2013-01-25 05:45:00	SPY	ETF	149.91	149.91	149.9	149.9	400.0
2013-01-25 05:50:00	SPY	ETF	149.91	149.91	149.91	149.91	7000.0
2013-01-25 06:00:00	SPY	ETF	149.92	149.99	149.91	149.96	8355.0
2013-01-25 06:05:00	SPY	ETF	149.91	149.94	149.9	149.94	1100.0
2013-01-25 06:10:00	SPY	ETF	149.89	149.89	149.84	149.87	44399.0
2013-01-25 06:15:00	SPY	ETF	149.86	149.86	149.81	149.81	2200.0
2013-01-25 06:25:00	SPY	ETF	149.82	149.84	149.82	149.84	200.0
2013-01-25 06:30:00	SPY	ETF	149.84	149.84	149.84	149.84	100.0
2013-01-25 06:35:00	SPY	ETF	149.86	149.86	149.86	149.86	1000.0
2013-01-25 06:40:00	SPY	ETF	149.87	149.87	149.84	149.84	11200.0
2013-01-25 06:45:00	SPY	ETF	149.85	149.86	149.85	149.86	400.0
2013-01-25 06:50:00	SPY	ETF	149.86	149.86	149.84	149.84	500.0
2013-01-25 06:55:00	SPY	ETF	149.87	149.94	149.87	149.91	4840.0
2013-01-25 07:00:00	SPY	ETF	149.89	149.92	149.87	149.91	41545.0
2013-01-25 07:05:00	SPY	ETF	149.91	149.95	149.9	149.91	40700.0
2013-01-25 07:10:00	SPY	ETF	149.92	149.97	149.92	149.95	69813.0
2013-01-25 07:15:00	SPY	ETF	149.96	149.98	149.95	149.98	21601.0
2013-01-25 07:20:00	SPY	ETF	149.99	150.04	149.99	150.01	20450.0
2013-01-25 07:25:00	SPY	ETF	150.02	150.02	149.97	149.99	29400.0
2013-01-25 07:30:00	SPY	ETF	150.01	150.02	149.98	150.0	126000.0
2013-01-25 07:35:00	SPY	ETF	150.02	150.09	150.01	150.07	24400.0
2013-01-25 07:40:00	SPY	ETF	150.08	150.1	150.06	150.1	35950.0
2013-01-25 07:45:00	SPY	ETF	150.1	150.12	150.07	150.08	69350.0
2013-01-25 07:50:00	SPY	ETF	150.06	150.07	150.01	150.01	45138.0
2013-01-25 07:55:00	SPY	ETF	150.04	150.05	149.99	150.0	139100.0
2013-01-25 08:00:00	SPY	ETF	149.98	150.07	149.93	149.94	200384.0
2013-01-25 08:05:00	SPY	ETF	149.94	149.95	149.9	149.92	16210.0
2013-01-25 08:10:00	SPY	ETF	149.93	149.97	149.92	149.97	33250.0
2013-01-25 08:15:00	SPY	ETF	149.98	150.03	149.97	150.03	49175.0
2013-01-25 08:20:00	SPY	ETF	150.03	150.05	149.99	150.03	57420.0
2013-01-25 08:25:00	SPY	ETF	150.035	150.05	150.0	150.05	123490.0
2013-01-25 08:30:00	SPY	ETF	150.05	150.06	149.95	149.95	35318.0
2013-01-25 08:35:00	SPY	ETF	149.94	149.96	149.92	149.95	51421.0
2013-01-25 08:40:00	SPY	ETF	149.95	149.95	149.92	149.92	53970.0
2013-01-25 08:45:00	SPY	ETF	149.93	149.945	149.89	149.94	162173.0
2013-01-25 08:50:00	SPY	ETF	149.95	149.95	149.91	149.92	54000.0
2013-01-25 08:55:00	SPY	ETF	149.92	149.94	149.88	149.91	69116.0

> showing 50 of 41,647 rows — these rows as CSV

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