PREVIEW / etf_5min / 2012-04-23

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-23.parquet
  size:    872 KB
  rows:    37,287

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-23 04:00:00	SPY	ETF	137.14	137.14	137.0	137.0	1100.0
2012-04-23 04:05:00	SPY	ETF	136.63	136.82	136.63	136.82	12700.0
2012-04-23 04:10:00	SPY	ETF	136.82	136.91	136.77	136.91	22100.0
2012-04-23 04:20:00	SPY	ETF	136.93	136.93	136.93	136.93	15000.0
2012-04-23 04:25:00	SPY	ETF	136.89	136.92	136.89	136.92	1000.0
2012-04-23 04:35:00	SPY	ETF	136.93	136.93	136.93	136.93	100.0
2012-04-23 04:40:00	SPY	ETF	136.94	136.94	136.94	136.94	700.0
2012-04-23 04:45:00	SPY	ETF	136.88	136.88	136.84	136.84	500.0
2012-04-23 04:55:00	SPY	ETF	136.8	136.8	136.8	136.8	100.0
2012-04-23 05:00:00	SPY	ETF	136.78	136.78	136.78	136.78	5000.0
2012-04-23 05:05:00	SPY	ETF	136.75	136.75	136.71	136.71	892.0
2012-04-23 05:10:00	SPY	ETF	136.79	136.79	136.79	136.79	170.0
2012-04-23 05:20:00	SPY	ETF	136.71	136.71	136.68	136.68	900.0
2012-04-23 05:25:00	SPY	ETF	136.63	136.63	136.62	136.62	4300.0
2012-04-23 05:30:00	SPY	ETF	136.66	136.66	136.56	136.56	3400.0
2012-04-23 05:35:00	SPY	ETF	136.56	136.61	136.56	136.61	30100.0
2012-04-23 05:40:00	SPY	ETF	136.62	136.62	136.62	136.62	100.0
2012-04-23 05:45:00	SPY	ETF	136.66	136.66	136.66	136.66	16000.0
2012-04-23 05:55:00	SPY	ETF	136.66	136.78	136.66	136.74	1695.0
2012-04-23 06:00:00	SPY	ETF	136.73	136.74	136.66	136.66	45300.0
2012-04-23 06:05:00	SPY	ETF	136.62	136.71	136.62	136.71	16700.0
2012-04-23 06:10:00	SPY	ETF	136.76	136.76	136.73	136.73	295.0
2012-04-23 06:15:00	SPY	ETF	136.72	136.74	136.72	136.74	51300.0
2012-04-23 06:25:00	SPY	ETF	136.68	136.68	136.68	136.68	100.0
2012-04-23 06:30:00	SPY	ETF	136.66	136.67	136.64	136.67	1595.0
2012-04-23 06:35:00	SPY	ETF	136.67	136.67	136.67	136.67	300.0
2012-04-23 06:40:00	SPY	ETF	136.65	136.71	136.64	136.67	1900.0
2012-04-23 06:45:00	SPY	ETF	136.65	136.65	136.58	136.61	6500.0
2012-04-23 06:50:00	SPY	ETF	136.63	136.73	136.61	136.73	30224.0
2012-04-23 06:55:00	SPY	ETF	136.69	136.74	136.68	136.7	32100.0
2012-04-23 07:00:00	SPY	ETF	136.65	136.68	136.57	136.57	128015.0
2012-04-23 07:05:00	SPY	ETF	136.53	136.6	136.5	136.59	61746.0
2012-04-23 07:10:00	SPY	ETF	136.62	136.62	136.6	136.6	3605.0
2012-04-23 07:15:00	SPY	ETF	136.61	136.71	136.6	136.71	55251.0
2012-04-23 07:20:00	SPY	ETF	136.73	136.73	136.64	136.7	77688.0
2012-04-23 07:25:00	SPY	ETF	136.7	136.73	136.67	136.73	39448.0
2012-04-23 07:30:00	SPY	ETF	136.73	136.73	136.6	136.61	24550.0
2012-04-23 07:35:00	SPY	ETF	136.63	136.63	136.51	136.52	59950.0
2012-04-23 07:40:00	SPY	ETF	136.5	136.64	136.5	136.64	22100.0
2012-04-23 07:45:00	SPY	ETF	136.64	136.72	136.62	136.71	24255.0
2012-04-23 07:50:00	SPY	ETF	136.69	136.7	136.67	136.7	24500.0
2012-04-23 07:55:00	SPY	ETF	136.7	136.78	136.66	136.66	49266.0
2012-04-23 08:00:00	SPY	ETF	136.67	137.8282	136.55	136.61	186969.0
2012-04-23 08:05:00	SPY	ETF	136.62	136.68	136.56	136.59	45275.0
2012-04-23 08:10:00	SPY	ETF	136.59	136.68	136.52	136.56	130226.0
2012-04-23 08:15:00	SPY	ETF	136.58	136.62	136.57	136.59	40576.0
2012-04-23 08:20:00	SPY	ETF	136.57	136.75	136.51	136.63	170066.0
2012-04-23 08:25:00	SPY	ETF	136.61	136.68	136.61	136.65	101683.0
2012-04-23 08:30:00	SPY	ETF	136.64	136.7	136.64	136.68	63857.0
2012-04-23 08:35:00	SPY	ETF	136.69	136.75	136.68	136.74	91337.0

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

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