PREVIEW / etf_5min / 2014-08-08

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-08.parquet
  size:    1010 KB
  rows:    42,362

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-08-08 04:00:00	SPY	ETF	189.94	189.94	189.61	189.75	22331.0
2014-08-08 04:05:00	SPY	ETF	189.75	189.8	189.7	189.79	4600.0
2014-08-08 04:10:00	SPY	ETF	189.78	189.81	189.76	189.79	4408.0
2014-08-08 04:15:00	SPY	ETF	189.76	189.81	189.76	189.78	2000.0
2014-08-08 04:20:00	SPY	ETF	189.84	190.01	189.84	189.97	7340.0
2014-08-08 04:25:00	SPY	ETF	190.02	190.11	190.02	190.11	1999.0
2014-08-08 04:30:00	SPY	ETF	190.12	190.21	190.12	190.18	1408.0
2014-08-08 04:35:00	SPY	ETF	190.23	190.35	190.23	190.3	5237.0
2014-08-08 04:40:00	SPY	ETF	190.35	190.41	190.26	190.28	41810.0
2014-08-08 04:45:00	SPY	ETF	190.35	190.35	190.32	190.32	1750.0
2014-08-08 04:50:00	SPY	ETF	190.37	190.45	190.37	190.4	7382.0
2014-08-08 04:55:00	SPY	ETF	190.38	190.38	190.29	190.3	1620.0
2014-08-08 05:00:00	SPY	ETF	190.25	190.3	190.21	190.25	7700.0
2014-08-08 05:05:00	SPY	ETF	190.24	190.35	190.24	190.25	6333.0
2014-08-08 05:10:00	SPY	ETF	190.23	190.27	190.18	190.27	3782.0
2014-08-08 05:15:00	SPY	ETF	190.3	190.3	190.26	190.26	2100.0
2014-08-08 05:20:00	SPY	ETF	190.37	190.37	190.35	190.35	225.0
2014-08-08 05:25:00	SPY	ETF	190.23	190.36	190.2	190.36	903.0
2014-08-08 05:30:00	SPY	ETF	190.32	190.32	190.32	190.32	100.0
2014-08-08 05:40:00	SPY	ETF	190.3	190.3	190.27	190.27	1339.0
2014-08-08 05:45:00	SPY	ETF	190.3	190.41	190.3	190.33	4235.0
2014-08-08 05:50:00	SPY	ETF	190.34	190.34	190.3	190.3	19025.0
2014-08-08 05:55:00	SPY	ETF	190.3	190.3	190.28	190.28	15427.0
2014-08-08 06:00:00	SPY	ETF	190.33	190.4	190.33	190.4	6715.0
2014-08-08 06:05:00	SPY	ETF	190.38	190.44	190.38	190.44	1185.0
2014-08-08 06:10:00	SPY	ETF	190.46	190.46	190.44	190.44	3699.0
2014-08-08 06:15:00	SPY	ETF	190.45	190.6	190.42	190.59	3598.0
2014-08-08 06:20:00	SPY	ETF	190.64	190.73	190.64	190.73	45707.0
2014-08-08 06:25:00	SPY	ETF	190.65	190.65	190.6	190.63	27300.0
2014-08-08 06:30:00	SPY	ETF	190.61	190.63	190.55	190.55	86428.0
2014-08-08 06:35:00	SPY	ETF	190.55	190.59	190.55	190.59	1200.0
2014-08-08 06:40:00	SPY	ETF	190.63	190.76	190.63	190.76	6050.0
2014-08-08 06:45:00	SPY	ETF	190.76	190.77	190.72	190.77	2600.0
2014-08-08 06:50:00	SPY	ETF	190.79	190.82	190.72	190.72	20318.0
2014-08-08 06:55:00	SPY	ETF	190.74	190.74	190.64	190.67	10810.0
2014-08-08 07:00:00	SPY	ETF	190.69	190.72	190.64	190.71	15862.0
2014-08-08 07:05:00	SPY	ETF	190.72	190.78	190.72	190.75	35508.0
2014-08-08 07:10:00	SPY	ETF	190.7	191.03	190.65	191.03	140804.0
2014-08-08 07:15:00	SPY	ETF	190.98	191.36	190.95	191.3	255487.0
2014-08-08 07:20:00	SPY	ETF	191.33	191.56	191.28	191.47	263262.0
2014-08-08 07:25:00	SPY	ETF	191.47	191.51	191.36	191.4	140660.0
2014-08-08 07:30:00	SPY	ETF	191.4	191.47	191.37	191.42	29969.0
2014-08-08 07:35:00	SPY	ETF	191.42	191.42	191.32	191.4	79490.0
2014-08-08 07:40:00	SPY	ETF	191.4	191.49	191.37	191.48	114870.0
2014-08-08 07:45:00	SPY	ETF	191.48	191.63	191.44	191.45	166742.0
2014-08-08 07:50:00	SPY	ETF	191.43	191.43	191.32	191.32	49892.0
2014-08-08 07:55:00	SPY	ETF	191.33	191.46	191.31	191.4	78395.0
2014-08-08 08:00:00	SPY	ETF	191.55	191.68	190.64	191.57	234868.0
2014-08-08 08:05:00	SPY	ETF	191.11	191.66	190.59	191.55	281845.0
2014-08-08 08:10:00	SPY	ETF	191.53	191.58	191.45	191.52	130605.0

> showing 50 of 42,362 rows — these rows as CSV

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