PREVIEW / etf_5min / 2011-11-14

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-11-14.parquet
  size:    840 KB
  rows:    34,417

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
2011-11-14 04:00:00	SPY	ETF	127.22	127.23	127.22	127.23	1500.0
2011-11-14 04:05:00	SPY	ETF	127.2	127.2	127.2	127.2	500.0
2011-11-14 04:10:00	SPY	ETF	127.0	127.0	126.92	126.92	1215.0
2011-11-14 04:20:00	SPY	ETF	126.81	126.85	126.81	126.85	1042.0
2011-11-14 04:25:00	SPY	ETF	126.84	126.84	126.84	126.84	100.0
2011-11-14 04:30:00	SPY	ETF	126.58	126.58	126.58	126.58	789.0
2011-11-14 04:35:00	SPY	ETF	126.75	126.75	126.75	126.75	1100.0
2011-11-14 04:40:00	SPY	ETF	126.75	126.75	126.62	126.65	10100.0
2011-11-14 04:45:00	SPY	ETF	126.71	126.71	126.71	126.71	200.0
2011-11-14 04:50:00	SPY	ETF	126.66	126.66	126.62	126.62	2900.0
2011-11-14 05:00:00	SPY	ETF	126.57	126.59	126.55	126.59	1600.0
2011-11-14 05:05:00	SPY	ETF	126.55	126.55	126.45	126.45	5300.0
2011-11-14 05:10:00	SPY	ETF	126.52	126.52	126.51	126.51	2000.0
2011-11-14 05:15:00	SPY	ETF	126.61	126.61	126.61	126.61	100.0
2011-11-14 05:20:00	SPY	ETF	126.83	126.83	126.83	126.83	200.0
2011-11-14 05:30:00	SPY	ETF	126.82	126.82	126.72	126.74	1700.0
2011-11-14 05:35:00	SPY	ETF	126.71	126.71	126.71	126.71	500.0
2011-11-14 05:40:00	SPY	ETF	126.68	126.68	126.64	126.64	2500.0
2011-11-14 05:45:00	SPY	ETF	126.64	126.66	126.58	126.58	1600.0
2011-11-14 05:55:00	SPY	ETF	126.53	126.53	126.5	126.5	1500.0
2011-11-14 06:00:00	SPY	ETF	126.45	126.45	126.31	126.31	10618.0
2011-11-14 06:05:00	SPY	ETF	126.33	126.34	126.22	126.34	18900.0
2011-11-14 06:10:00	SPY	ETF	126.31	126.31	126.16	126.16	7148.0
2011-11-14 06:15:00	SPY	ETF	126.2	126.24	126.14	126.14	7200.0
2011-11-14 06:20:00	SPY	ETF	126.18	126.18	126.1	126.1	9480.0
2011-11-14 06:25:00	SPY	ETF	126.1	126.21	126.0	126.19	14120.0
2011-11-14 06:30:00	SPY	ETF	126.17	126.19	126.15	126.19	2300.0
2011-11-14 06:35:00	SPY	ETF	126.19	126.25	126.19	126.25	4312.0
2011-11-14 06:40:00	SPY	ETF	126.28	126.32	126.23	126.23	3439.0
2011-11-14 06:45:00	SPY	ETF	126.26	126.26	126.23	126.25	23000.0
2011-11-14 06:50:00	SPY	ETF	126.34	126.35	126.26	126.26	15340.0
2011-11-14 06:55:00	SPY	ETF	126.26	126.26	126.16	126.17	9651.0
2011-11-14 07:00:00	SPY	ETF	126.15	126.15	125.85	125.94	41215.0
2011-11-14 07:05:00	SPY	ETF	125.85	125.99	125.76	125.92	52301.0
2011-11-14 07:10:00	SPY	ETF	126.04	126.04	125.95	126.01	41400.0
2011-11-14 07:15:00	SPY	ETF	126.0	126.06	125.95	125.98	59837.0
2011-11-14 07:20:00	SPY	ETF	125.98	126.09	125.98	126.02	63900.0
2011-11-14 07:25:00	SPY	ETF	126.01	126.03	125.98	126.0	64250.0
2011-11-14 07:30:00	SPY	ETF	126.01	126.01	125.82	125.85	70732.0
2011-11-14 07:35:00	SPY	ETF	125.84	126.04	125.78	126.0	34851.0
2011-11-14 07:40:00	SPY	ETF	126.01	126.09	125.93	126.06	27450.0
2011-11-14 07:45:00	SPY	ETF	126.05	126.06	125.95	125.97	60989.0
2011-11-14 07:50:00	SPY	ETF	126.0	126.18	126.0	126.1	37157.0
2011-11-14 07:55:00	SPY	ETF	126.15	126.15	126.07	126.11	49340.0
2011-11-14 08:00:00	SPY	ETF	126.2	126.2	125.8916	126.11	1675400.0
2011-11-14 08:05:00	SPY	ETF	126.12	126.19	126.09	126.17	72956.0
2011-11-14 08:10:00	SPY	ETF	126.18	126.25	126.17	126.22	51229.0
2011-11-14 08:15:00	SPY	ETF	126.23	126.26	126.21	126.25	146765.0
2011-11-14 08:20:00	SPY	ETF	126.26	126.26	126.15	126.17	269600.0
2011-11-14 08:25:00	SPY	ETF	126.16	126.23	126.16	126.2	37912.0

> showing 50 of 34,417 rows — these rows as CSV

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