PREVIEW / etf_5min / 2014-10-24

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-24.parquet
  size:    1.0 MB
  rows:    44,655

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
2014-10-24 04:00:00	SPY	ETF	194.84	194.98	194.84	194.98	1311.0
2014-10-24 04:05:00	SPY	ETF	195.07	195.07	194.89	194.9	15126.0
2014-10-24 04:10:00	SPY	ETF	194.88	194.88	194.87	194.87	1935.0
2014-10-24 04:15:00	SPY	ETF	194.9	194.9	194.83	194.83	5600.0
2014-10-24 04:20:00	SPY	ETF	194.75	194.83	194.75	194.82	4338.0
2014-10-24 04:25:00	SPY	ETF	194.84	194.84	194.75	194.8	15288.0
2014-10-24 04:30:00	SPY	ETF	194.8	194.8	194.72	194.72	6992.0
2014-10-24 04:40:00	SPY	ETF	194.81	194.85	194.78	194.78	2160.0
2014-10-24 04:45:00	SPY	ETF	194.8	194.97	194.8	194.92	6515.0
2014-10-24 04:50:00	SPY	ETF	194.92	194.95	194.85	194.95	2380.0
2014-10-24 04:55:00	SPY	ETF	194.9	194.9	194.83	194.84	8800.0
2014-10-24 05:00:00	SPY	ETF	194.8	194.8	194.76	194.8	1312.0
2014-10-24 05:05:00	SPY	ETF	194.81	194.81	194.61	194.7	5522.0
2014-10-24 05:10:00	SPY	ETF	194.74	194.82	194.71	194.73	10234.0
2014-10-24 05:15:00	SPY	ETF	194.75	194.8	194.75	194.8	452.0
2014-10-24 05:20:00	SPY	ETF	194.8	194.8	194.7	194.72	5986.0
2014-10-24 05:25:00	SPY	ETF	194.75	194.75	194.67	194.69	1275.0
2014-10-24 05:30:00	SPY	ETF	194.68	194.68	194.63	194.65	11898.0
2014-10-24 05:35:00	SPY	ETF	194.66	194.73	194.66	194.73	613.0
2014-10-24 05:40:00	SPY	ETF	194.74	194.75	194.73	194.75	873.0
2014-10-24 05:45:00	SPY	ETF	194.81	194.81	194.76	194.76	1246.0
2014-10-24 05:55:00	SPY	ETF	194.69	194.69	194.68	194.68	5220.0
2014-10-24 06:00:00	SPY	ETF	194.7	194.73	194.7	194.73	541.0
2014-10-24 06:10:00	SPY	ETF	194.65	194.65	194.62	194.65	507.0
2014-10-24 06:15:00	SPY	ETF	194.63	194.63	194.53	194.58	3030.0
2014-10-24 06:20:00	SPY	ETF	194.51	194.54	194.39	194.39	7375.0
2014-10-24 06:25:00	SPY	ETF	194.4	194.54	194.4	194.54	13250.0
2014-10-24 06:30:00	SPY	ETF	194.57	194.57	194.53	194.54	2550.0
2014-10-24 06:35:00	SPY	ETF	194.59	194.61	194.55	194.61	8950.0
2014-10-24 06:40:00	SPY	ETF	194.63	194.63	194.57	194.61	11280.0
2014-10-24 06:45:00	SPY	ETF	194.57	194.57	194.43	194.43	7450.0
2014-10-24 06:50:00	SPY	ETF	194.48	194.59	194.48	194.59	14052.0
2014-10-24 06:55:00	SPY	ETF	194.57	194.58	194.46	194.52	6285.0
2014-10-24 07:00:00	SPY	ETF	194.54	194.67	194.54	194.65	68262.0
2014-10-24 07:05:00	SPY	ETF	194.65	194.71	194.5	194.54	43945.0
2014-10-24 07:10:00	SPY	ETF	194.51	194.54	194.45	194.49	35292.0
2014-10-24 07:15:00	SPY	ETF	194.54	194.66	194.51	194.66	25262.0
2014-10-24 07:20:00	SPY	ETF	194.66	194.7	194.62	194.62	7866.0
2014-10-24 07:25:00	SPY	ETF	194.57	194.57	194.49	194.51	35446.0
2014-10-24 07:30:00	SPY	ETF	194.57	194.57	194.4	194.46	30052.0
2014-10-24 07:35:00	SPY	ETF	194.42	194.51	194.35	194.39	52399.0
2014-10-24 07:40:00	SPY	ETF	194.36	194.49	194.32	194.47	49305.0
2014-10-24 07:45:00	SPY	ETF	194.49	194.54	194.41	194.41	37516.0
2014-10-24 07:50:00	SPY	ETF	194.46	194.48	194.33	194.45	74570.0
2014-10-24 07:55:00	SPY	ETF	194.45	194.56	194.41	194.48	58926.0
2014-10-24 08:00:00	SPY	ETF	193.8318	194.65	193.8318	194.185	217298.0
2014-10-24 08:05:00	SPY	ETF	194.38	194.5	194.16	194.45	61165.0
2014-10-24 08:10:00	SPY	ETF	194.48	194.6	194.46	194.57	82511.0
2014-10-24 08:15:00	SPY	ETF	194.59	194.65	194.58	194.65	86343.0
2014-10-24 08:20:00	SPY	ETF	194.65	194.87	194.65	194.83	270572.0

> showing 50 of 44,655 rows — these rows as CSV

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