PREVIEW / etf_5min / 2014-01-23

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-01-23.parquet
  size:    1.1 MB
  rows:    47,362

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
2014-01-23 04:00:00	SPY	ETF	184.03	184.03	183.97	183.97	607.0
2014-01-23 04:05:00	SPY	ETF	183.93	183.93	183.89	183.89	833.0
2014-01-23 04:10:00	SPY	ETF	183.82	183.82	183.76	183.76	3030.0
2014-01-23 04:15:00	SPY	ETF	183.71	183.71	183.67	183.67	4997.0
2014-01-23 04:20:00	SPY	ETF	183.67	183.73	183.67	183.73	11600.0
2014-01-23 04:25:00	SPY	ETF	183.75	183.78	183.7	183.7	645.0
2014-01-23 04:30:00	SPY	ETF	183.78	183.78	183.78	183.78	515.0
2014-01-23 04:45:00	SPY	ETF	183.89	183.9	183.89	183.89	1800.0
2014-01-23 04:50:00	SPY	ETF	183.85	183.85	183.85	183.85	341.0
2014-01-23 04:55:00	SPY	ETF	183.85	183.85	183.8	183.8	2243.0
2014-01-23 05:00:00	SPY	ETF	183.85	183.85	183.85	183.85	250.0
2014-01-23 05:05:00	SPY	ETF	183.83	183.83	183.77	183.77	2428.0
2014-01-23 05:10:00	SPY	ETF	183.77	183.77	183.77	183.77	225.0
2014-01-23 05:15:00	SPY	ETF	183.77	183.82	183.77	183.82	1047.0
2014-01-23 05:20:00	SPY	ETF	183.88	183.88	183.88	183.88	500.0
2014-01-23 05:30:00	SPY	ETF	183.82	183.82	183.79	183.79	1625.0
2014-01-23 05:40:00	SPY	ETF	183.84	183.88	183.84	183.88	2600.0
2014-01-23 05:50:00	SPY	ETF	183.83	183.83	183.83	183.83	5000.0
2014-01-23 05:55:00	SPY	ETF	183.83	183.83	183.83	183.83	2500.0
2014-01-23 06:00:00	SPY	ETF	183.78	183.78	183.78	183.78	218.0
2014-01-23 06:10:00	SPY	ETF	183.76	183.76	183.59	183.6	4365.0
2014-01-23 06:20:00	SPY	ETF	183.69	183.75	183.69	183.75	3500.0
2014-01-23 06:25:00	SPY	ETF	183.7	183.73	183.7	183.7	16938.0
2014-01-23 06:35:00	SPY	ETF	183.7	183.7	183.68	183.68	2300.0
2014-01-23 06:40:00	SPY	ETF	183.67	183.67	183.67	183.67	300.0
2014-01-23 06:45:00	SPY	ETF	183.66	183.66	183.58	183.58	10400.0
2014-01-23 06:50:00	SPY	ETF	183.55	183.55	183.44	183.48	8950.0
2014-01-23 06:55:00	SPY	ETF	183.53	183.54	183.51	183.51	6659.0
2014-01-23 07:00:00	SPY	ETF	183.51	183.55	183.44	183.52	89917.0
2014-01-23 07:05:00	SPY	ETF	183.55	183.62	183.52	183.62	9600.0
2014-01-23 07:10:00	SPY	ETF	183.6	183.64	183.58	183.58	77775.0
2014-01-23 07:15:00	SPY	ETF	183.57	183.63	183.57	183.62	51400.0
2014-01-23 07:20:00	SPY	ETF	183.63	183.66	183.57	183.6	121180.0
2014-01-23 07:25:00	SPY	ETF	183.58	183.66	183.58	183.66	10029.0
2014-01-23 07:30:00	SPY	ETF	183.68	183.68	183.65	183.65	55380.0
2014-01-23 07:35:00	SPY	ETF	183.68	183.7	183.66	183.7	7903.0
2014-01-23 07:40:00	SPY	ETF	183.68	183.68	183.64	183.68	40015.0
2014-01-23 07:45:00	SPY	ETF	183.68	183.7	183.67	183.67	9673.0
2014-01-23 07:50:00	SPY	ETF	183.69	183.69	183.69	183.69	500.0
2014-01-23 07:55:00	SPY	ETF	183.7	183.75	183.7	183.73	7528.0
2014-01-23 08:00:00	SPY	ETF	183.68	183.76	183.61	183.72	51374.0
2014-01-23 08:05:00	SPY	ETF	183.72	183.76	183.71	183.74	34577.0
2014-01-23 08:10:00	SPY	ETF	183.75	184.73	183.74	183.76	26166.0
2014-01-23 08:15:00	SPY	ETF	183.78	183.78	183.75	183.77	110506.0
2014-01-23 08:20:00	SPY	ETF	183.76	183.78	183.75	183.76	44468.0
2014-01-23 08:25:00	SPY	ETF	183.76	183.78	183.7	183.73	30378.0
2014-01-23 08:30:00	SPY	ETF	183.73	183.74	183.62	183.74	86935.0
2014-01-23 08:35:00	SPY	ETF	183.74	183.76	183.72	183.75	9066.0
2014-01-23 08:40:00	SPY	ETF	183.755	183.76	183.65	183.67	81355.0
2014-01-23 08:45:00	SPY	ETF	183.67	183.67	183.58	183.58	92946.0

> showing 50 of 47,362 rows — these rows as CSV

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