PREVIEW / etf_5min / 2013-04-23

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-23.parquet
  size:    977 KB
  rows:    41,279

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-04-23 04:00:00	SPY	ETF	155.65	155.65	155.6	155.6	1100.0
2013-04-23 04:05:00	SPY	ETF	155.76	155.77	155.76	155.76	4500.0
2013-04-23 04:10:00	SPY	ETF	155.74	155.74	155.72	155.72	200.0
2013-04-23 04:15:00	SPY	ETF	155.7	155.7	155.6	155.65	2500.0
2013-04-23 04:20:00	SPY	ETF	155.65	155.65	155.65	155.65	500.0
2013-04-23 04:25:00	SPY	ETF	155.6	155.6	155.6	155.6	1000.0
2013-04-23 04:35:00	SPY	ETF	155.55	155.55	155.51	155.51	200.0
2013-04-23 04:40:00	SPY	ETF	155.5	155.5	155.43	155.45	11290.0
2013-04-23 04:45:00	SPY	ETF	155.44	155.44	155.35	155.35	4400.0
2013-04-23 04:50:00	SPY	ETF	155.4	155.46	155.4	155.45	14805.0
2013-04-23 04:55:00	SPY	ETF	155.42	155.42	155.42	155.42	1000.0
2013-04-23 05:00:00	SPY	ETF	155.55	155.55	155.55	155.55	200.0
2013-04-23 05:05:00	SPY	ETF	155.58	155.58	155.57	155.57	800.0
2013-04-23 05:15:00	SPY	ETF	155.59	155.6	155.57	155.6	400.0
2013-04-23 05:20:00	SPY	ETF	155.62	155.63	155.61	155.63	2600.0
2013-04-23 05:25:00	SPY	ETF	155.75	155.87	155.72	155.85	2600.0
2013-04-23 05:30:00	SPY	ETF	155.89	156.0	155.89	155.94	24399.0
2013-04-23 05:35:00	SPY	ETF	155.94	155.95	155.92	155.95	5800.0
2013-04-23 05:40:00	SPY	ETF	155.95	155.95	155.92	155.92	800.0
2013-04-23 05:45:00	SPY	ETF	155.92	155.92	155.9	155.9	11999.0
2013-04-23 05:50:00	SPY	ETF	155.92	155.92	155.86	155.86	11100.0
2013-04-23 05:55:00	SPY	ETF	155.87	155.87	155.87	155.87	100.0
2013-04-23 06:00:00	SPY	ETF	155.86	155.87	155.86	155.87	1100.0
2013-04-23 06:05:00	SPY	ETF	155.85	155.85	155.85	155.85	200.0
2013-04-23 06:10:00	SPY	ETF	155.85	155.85	155.85	155.85	200.0
2013-04-23 06:15:00	SPY	ETF	155.84	155.85	155.82	155.85	5700.0
2013-04-23 06:20:00	SPY	ETF	155.84	155.85	155.82	155.82	7700.0
2013-04-23 06:25:00	SPY	ETF	155.82	155.82	155.81	155.81	3400.0
2013-04-23 06:30:00	SPY	ETF	155.85	155.87	155.82	155.87	3500.0
2013-04-23 06:35:00	SPY	ETF	155.92	156.03	155.92	155.93	17311.0
2013-04-23 06:40:00	SPY	ETF	156.03	156.05	156.03	156.03	10200.0
2013-04-23 06:45:00	SPY	ETF	156.02	156.06	156.02	156.06	700.0
2013-04-23 06:50:00	SPY	ETF	156.07	156.1	156.05	156.06	7100.0
2013-04-23 06:55:00	SPY	ETF	156.06	156.15	156.06	156.15	15301.0
2013-04-23 07:00:00	SPY	ETF	156.15	156.22	156.15	156.2	17952.0
2013-04-23 07:05:00	SPY	ETF	156.2	156.34	156.19	156.34	92898.0
2013-04-23 07:10:00	SPY	ETF	156.35	156.36	156.3	156.36	19450.0
2013-04-23 07:15:00	SPY	ETF	156.35	156.37	156.31	156.32	49550.0
2013-04-23 07:20:00	SPY	ETF	156.32	156.35	156.31	156.35	17050.0
2013-04-23 07:25:00	SPY	ETF	156.37	156.37	156.34	156.36	8900.0
2013-04-23 07:30:00	SPY	ETF	156.35	156.37	156.34	156.37	74200.0
2013-04-23 07:35:00	SPY	ETF	156.36	156.37	156.36	156.37	5400.0
2013-04-23 07:40:00	SPY	ETF	156.37	156.37	156.29	156.3	20600.0
2013-04-23 07:45:00	SPY	ETF	156.3	156.49	156.3	156.44	77790.0
2013-04-23 07:50:00	SPY	ETF	156.42	156.47	156.41	156.47	25300.0
2013-04-23 07:55:00	SPY	ETF	156.44	156.51	156.41	156.5	129900.0
2013-04-23 08:00:00	SPY	ETF	156.5	156.69	156.12	156.69	273050.0
2013-04-23 08:05:00	SPY	ETF	156.68	156.72	156.63	156.71	70790.0
2013-04-23 08:10:00	SPY	ETF	156.7	156.7	156.62	156.62	40587.0
2013-04-23 08:15:00	SPY	ETF	156.64	156.71	156.64	156.71	274254.0

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

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