PREVIEW / etf_5min / 2012-11-08

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-11-08.parquet
  size:    942 KB
  rows:    38,734

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-11-08 04:10:00	SPY	ETF	139.89	139.89	139.89	139.89	300.0
2012-11-08 04:15:00	SPY	ETF	139.94	140.01	139.94	140.01	1600.0
2012-11-08 04:30:00	SPY	ETF	139.75	139.75	139.57	139.57	2660.0
2012-11-08 04:35:00	SPY	ETF	139.61	139.61	139.57	139.6	4500.0
2012-11-08 04:50:00	SPY	ETF	139.61	139.61	139.61	139.61	3000.0
2012-11-08 04:55:00	SPY	ETF	139.52	139.52	139.46	139.46	2100.0
2012-11-08 05:00:00	SPY	ETF	139.45	139.45	139.38	139.38	1400.0
2012-11-08 05:05:00	SPY	ETF	139.52	139.52	139.52	139.52	3000.0
2012-11-08 05:10:00	SPY	ETF	139.55	139.55	139.47	139.47	1500.0
2012-11-08 05:15:00	SPY	ETF	139.53	139.53	139.4	139.4	4700.0
2012-11-08 05:20:00	SPY	ETF	139.39	139.4	139.39	139.4	700.0
2012-11-08 05:25:00	SPY	ETF	139.47	139.47	139.47	139.47	1000.0
2012-11-08 05:30:00	SPY	ETF	139.58	139.59	139.58	139.59	33500.0
2012-11-08 05:35:00	SPY	ETF	139.6	139.6	139.6	139.6	9100.0
2012-11-08 05:40:00	SPY	ETF	139.65	139.65	139.65	139.65	1000.0
2012-11-08 05:45:00	SPY	ETF	139.6	139.63	139.6	139.63	16625.0
2012-11-08 05:50:00	SPY	ETF	139.7	139.73	139.7	139.72	11600.0
2012-11-08 05:55:00	SPY	ETF	139.7	139.7	139.65	139.65	5200.0
2012-11-08 06:00:00	SPY	ETF	139.59	139.59	139.49	139.53	3300.0
2012-11-08 06:05:00	SPY	ETF	139.57	139.63	139.57	139.63	2000.0
2012-11-08 06:10:00	SPY	ETF	139.65	139.65	139.65	139.65	1000.0
2012-11-08 06:15:00	SPY	ETF	139.65	139.66	139.58	139.58	15700.0
2012-11-08 06:20:00	SPY	ETF	139.6	139.6	139.6	139.6	100.0
2012-11-08 06:25:00	SPY	ETF	139.6	139.61	139.6	139.61	15000.0
2012-11-08 06:30:00	SPY	ETF	139.65	139.68	139.64	139.68	48200.0
2012-11-08 06:35:00	SPY	ETF	139.67	139.72	139.67	139.7	5060.0
2012-11-08 06:40:00	SPY	ETF	139.75	139.75	139.75	139.75	19998.0
2012-11-08 06:45:00	SPY	ETF	139.69	139.69	139.66	139.66	3400.0
2012-11-08 06:50:00	SPY	ETF	139.68	139.68	139.68	139.68	100.0
2012-11-08 06:55:00	SPY	ETF	139.74	139.78	139.74	139.75	44199.0
2012-11-08 07:00:00	SPY	ETF	139.75	139.82	139.7	139.71	24488.0
2012-11-08 07:05:00	SPY	ETF	139.75	139.8	139.75	139.8	31100.0
2012-11-08 07:10:00	SPY	ETF	139.88	139.88	139.78	139.78	18300.0
2012-11-08 07:15:00	SPY	ETF	139.8	139.8	139.76	139.76	3026.0
2012-11-08 07:20:00	SPY	ETF	139.79	139.8	139.69	139.69	17480.0
2012-11-08 07:25:00	SPY	ETF	139.7	139.78	139.69	139.76	17445.0
2012-11-08 07:30:00	SPY	ETF	139.75	139.82	139.72	139.8	10800.0
2012-11-08 07:35:00	SPY	ETF	139.83	139.95	139.81	139.95	9785.0
2012-11-08 07:40:00	SPY	ETF	139.95	140.04	139.95	140.0	66847.0
2012-11-08 07:45:00	SPY	ETF	140.01	140.1	139.89	140.1	59525.0
2012-11-08 07:50:00	SPY	ETF	140.1	140.13	140.08	140.11	68875.0
2012-11-08 07:55:00	SPY	ETF	140.12	140.17	140.1	140.1	33500.0
2012-11-08 08:00:00	SPY	ETF	140.09	140.1	139.69	139.99	211345.0
2012-11-08 08:05:00	SPY	ETF	140.0	140.0	139.9	139.9	44387.0
2012-11-08 08:10:00	SPY	ETF	139.9	140.01	139.9	139.97	49462.0
2012-11-08 08:15:00	SPY	ETF	139.99	140.03	139.95	139.95	40938.0
2012-11-08 08:20:00	SPY	ETF	139.92	139.93	139.9	139.93	200048.0
2012-11-08 08:25:00	SPY	ETF	139.92	139.97	139.89	139.95	42222.0
2012-11-08 08:30:00	SPY	ETF	139.95	140.31	139.87	139.9	179341.0
2012-11-08 08:35:00	SPY	ETF	139.91	140.06	139.9	140.0	89728.0

> showing 50 of 38,734 rows — these rows as CSV

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