PREVIEW / etf_5min / 2014-01-29

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-01-29.parquet
  size:    1.1 MB
  rows:    45,761

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-01-29 04:00:00	SPY	ETF	180.05	180.05	179.97	179.97	43240.0
2014-01-29 04:05:00	SPY	ETF	179.92	179.92	179.77	179.77	28500.0
2014-01-29 04:10:00	SPY	ETF	179.77	179.77	179.44	179.45	56275.0
2014-01-29 04:15:00	SPY	ETF	179.45	179.58	179.43	179.56	16204.0
2014-01-29 04:20:00	SPY	ETF	179.55	179.58	179.54	179.58	430.0
2014-01-29 04:25:00	SPY	ETF	179.6	179.6	179.6	179.6	500.0
2014-01-29 04:30:00	SPY	ETF	179.67	179.67	179.62	179.62	417.0
2014-01-29 04:35:00	SPY	ETF	179.55	179.61	179.55	179.61	1400.0
2014-01-29 04:40:00	SPY	ETF	179.68	179.78	179.68	179.76	4595.0
2014-01-29 04:45:00	SPY	ETF	179.66	179.66	179.66	179.66	230.0
2014-01-29 04:50:00	SPY	ETF	179.73	179.73	179.7	179.7	2200.0
2014-01-29 04:55:00	SPY	ETF	179.74	179.74	179.7	179.72	599.0
2014-01-29 05:00:00	SPY	ETF	179.7	179.7	179.7	179.7	341.0
2014-01-29 05:05:00	SPY	ETF	179.69	179.69	179.67	179.67	200.0
2014-01-29 05:10:00	SPY	ETF	179.62	179.62	179.62	179.62	301.0
2014-01-29 05:15:00	SPY	ETF	179.64	179.64	179.55	179.55	13125.0
2014-01-29 05:20:00	SPY	ETF	179.57	179.57	179.55	179.57	898.0
2014-01-29 05:25:00	SPY	ETF	179.6	179.65	179.6	179.63	3200.0
2014-01-29 05:30:00	SPY	ETF	179.64	179.65	179.59	179.59	20200.0
2014-01-29 05:35:00	SPY	ETF	179.57	179.57	179.45	179.48	1594.0
2014-01-29 05:40:00	SPY	ETF	179.43	179.43	179.26	179.29	17454.0
2014-01-29 05:45:00	SPY	ETF	179.3	179.33	179.3	179.31	1425.0
2014-01-29 05:50:00	SPY	ETF	179.3	179.33	179.3	179.33	431.0
2014-01-29 05:55:00	SPY	ETF	179.26	179.4	179.26	179.4	2190.0
2014-01-29 06:00:00	SPY	ETF	179.35	179.35	179.3	179.3	400.0
2014-01-29 06:05:00	SPY	ETF	179.32	179.33	179.23	179.23	2450.0
2014-01-29 06:10:00	SPY	ETF	179.35	179.35	179.19	179.19	5909.0
2014-01-29 06:15:00	SPY	ETF	179.25	179.28	179.24	179.24	1518.0
2014-01-29 06:20:00	SPY	ETF	179.21	179.33	179.21	179.28	19545.0
2014-01-29 06:25:00	SPY	ETF	179.28	179.33	179.28	179.33	5015.0
2014-01-29 06:30:00	SPY	ETF	179.34	179.35	179.16	179.16	10637.0
2014-01-29 06:35:00	SPY	ETF	179.13	179.14	178.82	178.87	25996.0
2014-01-29 06:40:00	SPY	ETF	178.84	178.95	178.84	178.85	27166.0
2014-01-29 06:45:00	SPY	ETF	178.91	179.05	178.91	179.0	40004.0
2014-01-29 06:50:00	SPY	ETF	179.0	179.0	178.94	178.99	6670.0
2014-01-29 06:55:00	SPY	ETF	179.09	179.23	179.09	179.11	454635.0
2014-01-29 07:00:00	SPY	ETF	179.19	179.19	179.1	179.17	108400.0
2014-01-29 07:05:00	SPY	ETF	179.15	179.47	179.15	179.46	29045.0
2014-01-29 07:10:00	SPY	ETF	179.4	179.41	179.38	179.4	6450.0
2014-01-29 07:15:00	SPY	ETF	179.36	179.39	179.33	179.35	135450.0
2014-01-29 07:20:00	SPY	ETF	179.32	179.32	179.2	179.2	114822.0
2014-01-29 07:25:00	SPY	ETF	179.17	179.27	178.78	178.9	268348.0
2014-01-29 07:30:00	SPY	ETF	178.87	179.03	178.84	178.88	222374.0
2014-01-29 07:35:00	SPY	ETF	178.88	179.01	178.5	178.56	454168.0
2014-01-29 07:40:00	SPY	ETF	178.56	178.68	178.49	178.56	210521.0
2014-01-29 07:45:00	SPY	ETF	178.56	178.63	178.36	178.41	296082.0
2014-01-29 07:50:00	SPY	ETF	178.41	178.82	178.38	178.69	333589.0
2014-01-29 07:55:00	SPY	ETF	178.69	178.79	178.6	178.69	176998.0
2014-01-29 08:00:00	SPY	ETF	178.7	179.39	178.3874	178.8	447626.0
2014-01-29 08:05:00	SPY	ETF	178.78	178.9	178.78	178.81	408997.0

> showing 50 of 45,761 rows — these rows as CSV

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