PREVIEW / etf_5min / 2013-01-03

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-03.parquet
  size:    1009 KB
  rows:    42,978

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-03 04:10:00	SPY	ETF	145.65	145.67	145.65	145.67	5555.0
2013-01-03 04:20:00	SPY	ETF	145.72	145.72	145.7	145.7	3000.0
2013-01-03 04:35:00	SPY	ETF	145.62	145.62	145.62	145.62	3000.0
2013-01-03 04:40:00	SPY	ETF	145.62	145.62	145.62	145.62	3000.0
2013-01-03 04:45:00	SPY	ETF	145.66	145.66	145.66	145.66	100.0
2013-01-03 05:05:00	SPY	ETF	145.63	145.63	145.63	145.63	100.0
2013-01-03 05:30:00	SPY	ETF	145.66	145.66	145.66	145.66	200.0
2013-01-03 05:40:00	SPY	ETF	145.68	145.68	145.67	145.67	6400.0
2013-01-03 05:45:00	SPY	ETF	145.73	145.73	145.73	145.73	100.0
2013-01-03 06:00:00	SPY	ETF	145.67	145.67	145.67	145.67	1200.0
2013-01-03 06:30:00	SPY	ETF	145.65	145.65	145.65	145.65	300.0
2013-01-03 06:35:00	SPY	ETF	145.62	145.67	145.62	145.67	450.0
2013-01-03 06:40:00	SPY	ETF	145.69	145.7	145.69	145.7	19000.0
2013-01-03 06:45:00	SPY	ETF	145.67	145.67	145.67	145.67	200.0
2013-01-03 06:50:00	SPY	ETF	145.65	145.65	145.65	145.65	7000.0
2013-01-03 06:55:00	SPY	ETF	145.65	145.65	145.59	145.59	2000.0
2013-01-03 07:00:00	SPY	ETF	145.62	145.62	145.58	145.62	12805.0
2013-01-03 07:05:00	SPY	ETF	145.62	145.65	145.6	145.64	14050.0
2013-01-03 07:10:00	SPY	ETF	145.6	145.62	145.6	145.6	6162.0
2013-01-03 07:15:00	SPY	ETF	145.64	145.64	145.6	145.6	10664.0
2013-01-03 07:20:00	SPY	ETF	145.61	145.63	145.6	145.61	23000.0
2013-01-03 07:25:00	SPY	ETF	145.63	145.65	145.61	145.63	50710.0
2013-01-03 07:30:00	SPY	ETF	145.64	145.65	145.63	145.65	31600.0
2013-01-03 07:35:00	SPY	ETF	145.65	145.65	145.61	145.62	1000.0
2013-01-03 07:40:00	SPY	ETF	145.61	145.65	145.61	145.64	13636.0
2013-01-03 07:45:00	SPY	ETF	145.64	145.64	145.61	145.61	30432.0
2013-01-03 07:50:00	SPY	ETF	145.61	145.66	145.61	145.65	8360.0
2013-01-03 07:55:00	SPY	ETF	145.65	145.66	145.63	145.65	57630.0
2013-01-03 08:00:00	SPY	ETF	145.65	145.71	145.6	145.68	69411.0
2013-01-03 08:05:00	SPY	ETF	145.67	145.68	145.62	145.64	17900.0
2013-01-03 08:10:00	SPY	ETF	145.63	145.66	145.59	145.63	17413.0
2013-01-03 08:15:00	SPY	ETF	145.63	146.15	145.63	145.84	329667.0
2013-01-03 08:20:00	SPY	ETF	145.84	145.99	145.83	145.91	114917.0
2013-01-03 08:25:00	SPY	ETF	145.91	146.03	145.89	146.01	160548.0
2013-01-03 08:30:00	SPY	ETF	146.01	146.02	145.81	145.95	138031.0
2013-01-03 08:35:00	SPY	ETF	145.95	145.96	145.77	145.83	159377.0
2013-01-03 08:40:00	SPY	ETF	145.83	145.85	145.79	145.85	224697.0
2013-01-03 08:45:00	SPY	ETF	145.86	145.98	145.83	145.97	446465.0
2013-01-03 08:50:00	SPY	ETF	145.98	145.99	145.88	145.89	602970.0
2013-01-03 08:55:00	SPY	ETF	145.9	145.92	145.85	145.9	146150.0
2013-01-03 09:00:00	SPY	ETF	145.91	145.93	145.87	145.91	89816.0
2013-01-03 09:05:00	SPY	ETF	145.92	145.93	145.85	145.86	41972.0
2013-01-03 09:10:00	SPY	ETF	145.86	145.89	145.84	145.87	19585.0
2013-01-03 09:15:00	SPY	ETF	145.88	145.91	145.88	145.89	20052.0
2013-01-03 09:20:00	SPY	ETF	145.87	145.96	145.87	145.92	40790.0
2013-01-03 09:25:00	SPY	ETF	145.92	146.0	145.91	145.99	480988.0
2013-01-03 09:30:00	SPY	ETF	145.99	145.99	145.73	145.75	3730462.0
2013-01-03 09:35:00	SPY	ETF	145.76	145.79	145.66	145.71	2869388.0
2013-01-03 09:40:00	SPY	ETF	145.72	145.73	145.61	145.675	2449620.0
2013-01-03 09:45:00	SPY	ETF	145.68	145.82	145.67	145.72	2628827.0

> showing 50 of 42,978 rows — these rows as CSV

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