PREVIEW / etf_5min / 2012-10-11

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-10-11.parquet
  size:    836 KB
  rows:    35,176

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-10-11 04:00:00	SPY	ETF	143.3	143.32	143.3	143.32	300.0
2012-10-11 04:05:00	SPY	ETF	143.48	143.48	143.48	143.48	200.0
2012-10-11 04:20:00	SPY	ETF	143.57	143.57	143.57	143.57	918.0
2012-10-11 04:35:00	SPY	ETF	143.7	143.72	143.7	143.72	1100.0
2012-10-11 04:40:00	SPY	ETF	143.6	143.6	143.6	143.6	644.0
2012-10-11 04:45:00	SPY	ETF	143.62	143.62	143.62	143.62	100.0
2012-10-11 05:00:00	SPY	ETF	143.6	143.62	143.6	143.62	2099.0
2012-10-11 05:05:00	SPY	ETF	143.64	143.64	143.64	143.64	100.0
2012-10-11 05:25:00	SPY	ETF	143.69	143.7	143.69	143.7	20500.0
2012-10-11 05:35:00	SPY	ETF	143.67	143.7	143.66	143.7	8800.0
2012-10-11 05:55:00	SPY	ETF	143.67	143.7	143.67	143.7	2500.0
2012-10-11 06:00:00	SPY	ETF	143.7	143.73	143.7	143.73	2000.0
2012-10-11 06:05:00	SPY	ETF	143.72	143.72	143.7	143.7	3600.0
2012-10-11 06:20:00	SPY	ETF	143.71	143.71	143.65	143.7	41200.0
2012-10-11 06:25:00	SPY	ETF	143.71	143.8	143.71	143.8	8550.0
2012-10-11 06:30:00	SPY	ETF	143.75	143.8	143.75	143.8	2800.0
2012-10-11 06:35:00	SPY	ETF	143.8	143.81	143.8	143.81	1000.0
2012-10-11 06:40:00	SPY	ETF	143.75	143.77	143.75	143.75	833.0
2012-10-11 06:45:00	SPY	ETF	143.75	143.75	143.75	143.75	21100.0
2012-10-11 06:50:00	SPY	ETF	143.77	143.8	143.75	143.77	24500.0
2012-10-11 06:55:00	SPY	ETF	143.8	143.83	143.77	143.8	5400.0
2012-10-11 07:00:00	SPY	ETF	143.78	143.78	143.77	143.77	10135.0
2012-10-11 07:05:00	SPY	ETF	143.75	143.78	143.75	143.75	10819.0
2012-10-11 07:10:00	SPY	ETF	143.72	143.78	143.72	143.75	14650.0
2012-10-11 07:15:00	SPY	ETF	143.76	143.83	143.76	143.8	16055.0
2012-10-11 07:20:00	SPY	ETF	143.78	143.78	143.72	143.76	45800.0
2012-10-11 07:25:00	SPY	ETF	143.75	143.77	143.7	143.77	79000.0
2012-10-11 07:30:00	SPY	ETF	143.72	143.72	143.68	143.68	16550.0
2012-10-11 07:35:00	SPY	ETF	143.65	143.66	143.63	143.65	30972.0
2012-10-11 07:40:00	SPY	ETF	143.63	143.73	143.63	143.73	27600.0
2012-10-11 07:45:00	SPY	ETF	143.7	143.76	143.65	143.65	37742.0
2012-10-11 07:50:00	SPY	ETF	143.62	143.69	143.62	143.66	36450.0
2012-10-11 07:55:00	SPY	ETF	143.62	143.66	143.6	143.6	9575.0
2012-10-11 08:00:00	SPY	ETF	143.61	143.73	143.42	143.68	133566.0
2012-10-11 08:05:00	SPY	ETF	143.63	143.7	143.63	143.68	102887.0
2012-10-11 08:10:00	SPY	ETF	143.68	143.74	143.68	143.7	146906.0
2012-10-11 08:15:00	SPY	ETF	143.73	143.8	143.69	143.74	72550.0
2012-10-11 08:20:00	SPY	ETF	143.74	143.8	143.74	143.77	48209.0
2012-10-11 08:25:00	SPY	ETF	143.78	143.95	143.78	143.88	124592.0
2012-10-11 08:30:00	SPY	ETF	143.89	144.11	143.76	143.95	898108.0
2012-10-11 08:35:00	SPY	ETF	143.94	143.99	143.92	143.95	759425.0
2012-10-11 08:40:00	SPY	ETF	143.95	144.0	143.93	143.99	118003.0
2012-10-11 08:45:00	SPY	ETF	143.98	143.98	143.94	143.96	128823.0
2012-10-11 08:50:00	SPY	ETF	143.97	143.99	143.96	143.98	37676.0
2012-10-11 08:55:00	SPY	ETF	143.97	143.98	143.93	143.95	40160.0
2012-10-11 09:00:00	SPY	ETF	143.94	144.0	143.93	143.98	84043.0
2012-10-11 09:05:00	SPY	ETF	143.99	144.09	143.98	144.09	151199.0
2012-10-11 09:10:00	SPY	ETF	144.09	144.25	144.08	144.22	320844.0
2012-10-11 09:15:00	SPY	ETF	144.23	144.26	143.9913	144.15	1010563.0
2012-10-11 09:20:00	SPY	ETF	144.15	144.21	143.28	144.21	192067.0

> showing 50 of 35,176 rows — these rows as CSV

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