PREVIEW / etf_5min / 2014-07-22

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-22.parquet
  size:    954 KB
  rows:    41,931

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-07-22 04:00:00	SPY	ETF	197.36	197.36	197.36	197.36	475.0
2014-07-22 04:20:00	SPY	ETF	197.3	197.3	197.3	197.3	300.0
2014-07-22 04:30:00	SPY	ETF	197.32	197.36	197.32	197.36	326.0
2014-07-22 04:45:00	SPY	ETF	197.34	197.34	197.34	197.34	100.0
2014-07-22 04:55:00	SPY	ETF	197.39	197.54	197.39	197.54	632.0
2014-07-22 05:00:00	SPY	ETF	197.49	197.6	197.49	197.5	568.0
2014-07-22 05:05:00	SPY	ETF	197.56	197.56	197.56	197.56	221.0
2014-07-22 05:10:00	SPY	ETF	197.5	197.5	197.5	197.5	400.0
2014-07-22 05:15:00	SPY	ETF	197.56	197.56	197.56	197.56	329.0
2014-07-22 05:25:00	SPY	ETF	197.63	197.63	197.63	197.63	100.0
2014-07-22 05:30:00	SPY	ETF	197.69	197.69	197.69	197.69	9475.0
2014-07-22 05:35:00	SPY	ETF	197.73	197.73	197.73	197.73	400.0
2014-07-22 05:40:00	SPY	ETF	197.75	197.75	197.75	197.75	2600.0
2014-07-22 05:45:00	SPY	ETF	197.78	197.78	197.78	197.78	25100.0
2014-07-22 05:55:00	SPY	ETF	197.75	197.75	197.75	197.75	150.0
2014-07-22 06:00:00	SPY	ETF	197.73	197.73	197.73	197.73	177.0
2014-07-22 06:15:00	SPY	ETF	197.75	197.75	197.75	197.75	1000.0
2014-07-22 06:25:00	SPY	ETF	197.74	197.76	197.7	197.7	12601.0
2014-07-22 06:35:00	SPY	ETF	197.65	197.65	197.65	197.65	460.0
2014-07-22 06:40:00	SPY	ETF	197.59	197.86	197.59	197.86	23920.0
2014-07-22 06:45:00	SPY	ETF	197.73	197.79	197.59	197.79	51063.0
2014-07-22 06:50:00	SPY	ETF	197.71	197.85	197.71	197.84	21550.0
2014-07-22 06:55:00	SPY	ETF	197.68	197.71	197.68	197.71	324.0
2014-07-22 07:00:00	SPY	ETF	197.7	197.74	197.7	197.74	2300.0
2014-07-22 07:05:00	SPY	ETF	197.74	197.79	197.74	197.74	3900.0
2014-07-22 07:10:00	SPY	ETF	197.75	197.75	197.71	197.71	4250.0
2014-07-22 07:15:00	SPY	ETF	197.71	197.73	197.62	197.73	6350.0
2014-07-22 07:20:00	SPY	ETF	197.73	197.73	197.72	197.72	8071.0
2014-07-22 07:25:00	SPY	ETF	197.74	197.76	197.74	197.76	15029.0
2014-07-22 07:30:00	SPY	ETF	197.77	197.78	197.76	197.77	4882.0
2014-07-22 07:35:00	SPY	ETF	197.76	197.87	197.75	197.84	46950.0
2014-07-22 07:40:00	SPY	ETF	197.83	197.97	197.83	197.94	117035.0
2014-07-22 07:45:00	SPY	ETF	197.92	197.94	197.85	197.86	29374.0
2014-07-22 07:50:00	SPY	ETF	197.86	197.87	197.74	197.74	75342.0
2014-07-22 07:55:00	SPY	ETF	197.76	197.8	197.74	197.76	33444.0
2014-07-22 08:00:00	SPY	ETF	197.77	197.93	197.67	197.77	60674.0
2014-07-22 08:05:00	SPY	ETF	197.78	197.88	197.78	197.86	48268.0
2014-07-22 08:10:00	SPY	ETF	197.86	197.88	197.8	197.88	52435.0
2014-07-22 08:15:00	SPY	ETF	197.87	197.89	197.85	197.86	62079.0
2014-07-22 08:20:00	SPY	ETF	197.86	197.91	197.82	197.83	79561.0
2014-07-22 08:25:00	SPY	ETF	197.83	198.01	197.77	197.83	35606.0
2014-07-22 08:30:00	SPY	ETF	197.83	198.09	197.8	198.02	266562.0
2014-07-22 08:35:00	SPY	ETF	198.0	198.01	197.92	197.96	145881.0
2014-07-22 08:40:00	SPY	ETF	197.96	198.0	197.94	197.98	39724.0
2014-07-22 08:45:00	SPY	ETF	197.99	198.03	197.94	197.94	44961.0
2014-07-22 08:50:00	SPY	ETF	197.96	197.99	197.95	197.98	52886.0
2014-07-22 08:55:00	SPY	ETF	197.97	198.0	197.91	197.92	38566.0
2014-07-22 09:00:00	SPY	ETF	197.92	197.92	197.86	197.86	75011.0
2014-07-22 09:05:00	SPY	ETF	197.85	197.97	197.85	197.97	44503.0
2014-07-22 09:10:00	SPY	ETF	197.97	197.99	197.93	197.97	131610.0

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

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