PREVIEW / etf_5min / 2013-05-24

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-24.parquet
  size:    930 KB
  rows:    39,435

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
2013-05-24 04:00:00	SPY	ETF	165.35	165.37	165.35	165.37	60000.0
2013-05-24 04:05:00	SPY	ETF	165.38	165.46	165.36	165.46	430.0
2013-05-24 04:10:00	SPY	ETF	165.4	165.4	165.4	165.4	32900.0
2013-05-24 04:15:00	SPY	ETF	165.45	165.45	165.45	165.45	1100.0
2013-05-24 04:30:00	SPY	ETF	165.73	165.73	165.71	165.73	25500.0
2013-05-24 04:35:00	SPY	ETF	165.63	165.63	165.6	165.6	10300.0
2013-05-24 04:50:00	SPY	ETF	165.56	165.56	165.56	165.56	200.0
2013-05-24 05:00:00	SPY	ETF	165.53	165.53	165.53	165.53	100.0
2013-05-24 05:15:00	SPY	ETF	165.51	165.51	165.46	165.46	3500.0
2013-05-24 05:20:00	SPY	ETF	165.43	165.43	165.43	165.43	1500.0
2013-05-24 05:25:00	SPY	ETF	165.3	165.3	165.3	165.3	1000.0
2013-05-24 05:30:00	SPY	ETF	165.17	165.17	165.0	165.0	18600.0
2013-05-24 05:35:00	SPY	ETF	164.98	165.0	164.97	165.0	400.0
2013-05-24 05:40:00	SPY	ETF	165.01	165.01	165.01	165.01	1300.0
2013-05-24 05:45:00	SPY	ETF	165.0	165.0	164.98	164.98	5400.0
2013-05-24 05:50:00	SPY	ETF	165.05	165.05	164.97	165.0	2900.0
2013-05-24 05:55:00	SPY	ETF	165.0	165.0	164.97	164.97	16000.0
2013-05-24 06:05:00	SPY	ETF	165.02	165.02	164.96	165.0	26900.0
2013-05-24 06:10:00	SPY	ETF	164.97	164.97	164.85	164.85	24350.0
2013-05-24 06:15:00	SPY	ETF	164.92	164.92	164.92	164.92	100.0
2013-05-24 06:20:00	SPY	ETF	164.94	164.94	164.93	164.93	1500.0
2013-05-24 06:25:00	SPY	ETF	164.91	164.97	164.9	164.97	4500.0
2013-05-24 06:30:00	SPY	ETF	164.94	164.98	164.87	164.87	20200.0
2013-05-24 06:35:00	SPY	ETF	164.89	164.89	164.8	164.87	19620.0
2013-05-24 06:40:00	SPY	ETF	164.84	164.87	164.8	164.8	900.0
2013-05-24 06:45:00	SPY	ETF	164.85	164.89	164.85	164.88	20600.0
2013-05-24 06:50:00	SPY	ETF	164.85	164.85	164.66	164.68	13750.0
2013-05-24 06:55:00	SPY	ETF	164.67	164.75	164.61	164.7	21050.0
2013-05-24 07:00:00	SPY	ETF	164.7	164.7	164.65	164.66	27960.0
2013-05-24 07:05:00	SPY	ETF	164.68	164.75	164.55	164.55	43585.0
2013-05-24 07:10:00	SPY	ETF	164.53	164.59	164.5	164.55	43645.0
2013-05-24 07:15:00	SPY	ETF	164.55	164.56	164.4	164.52	15442.0
2013-05-24 07:20:00	SPY	ETF	164.46	164.53	164.46	164.53	51160.0
2013-05-24 07:25:00	SPY	ETF	164.53	164.58	164.5	164.58	10350.0
2013-05-24 07:30:00	SPY	ETF	164.58	164.64	164.5	164.63	119695.0
2013-05-24 07:35:00	SPY	ETF	164.62	164.68	164.44	164.48	95964.0
2013-05-24 07:40:00	SPY	ETF	164.47	164.63	164.47	164.59	40595.0
2013-05-24 07:45:00	SPY	ETF	164.6	164.64	164.6	164.6	11600.0
2013-05-24 07:50:00	SPY	ETF	164.65	164.79	164.65	164.75	28505.0
2013-05-24 07:55:00	SPY	ETF	164.79	164.83	164.72	164.77	43372.0
2013-05-24 08:00:00	SPY	ETF	164.78	164.83	164.48	164.78	79261.0
2013-05-24 08:05:00	SPY	ETF	164.8	164.9	164.8	164.85	184590.0
2013-05-24 08:10:00	SPY	ETF	164.82	164.87	164.79	164.84	49350.0
2013-05-24 08:15:00	SPY	ETF	164.83	164.87	164.78	164.85	129683.0
2013-05-24 08:20:00	SPY	ETF	164.86	164.89	164.83	164.87	119946.0
2013-05-24 08:25:00	SPY	ETF	164.89	164.94	164.87	164.88	33270.0
2013-05-24 08:30:00	SPY	ETF	164.88	165.26	164.81	165.07	553120.0
2013-05-24 08:35:00	SPY	ETF	165.07	165.13	164.79	164.91	208733.0
2013-05-24 08:40:00	SPY	ETF	164.92	164.92	164.78	164.82	125960.0
2013-05-24 08:45:00	SPY	ETF	164.82	164.82	164.67	164.72	334361.0

> showing 50 of 39,435 rows — these rows as CSV

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