PREVIEW / etf_5min / 2013-05-01

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-01.parquet
  size:    1006 KB
  rows:    41,439

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-01 04:35:00	SPY	ETF	159.87	159.87	159.87	159.87	100.0
2013-05-01 04:40:00	SPY	ETF	159.9	159.9	159.9	159.9	100.0
2013-05-01 05:00:00	SPY	ETF	159.97	159.97	159.94	159.94	500.0
2013-05-01 05:05:00	SPY	ETF	159.97	159.98	159.97	159.97	800.0
2013-05-01 05:10:00	SPY	ETF	159.97	159.97	159.89	159.89	900.0
2013-05-01 05:15:00	SPY	ETF	159.88	159.88	159.86	159.86	200.0
2013-05-01 05:30:00	SPY	ETF	159.86	159.86	159.86	159.86	100.0
2013-05-01 05:45:00	SPY	ETF	159.92	159.95	159.92	159.95	200.0
2013-05-01 05:55:00	SPY	ETF	159.89	159.89	159.89	159.89	6000.0
2013-05-01 06:15:00	SPY	ETF	159.86	159.86	159.85	159.85	600.0
2013-05-01 06:20:00	SPY	ETF	159.85	159.85	159.85	159.85	4000.0
2013-05-01 06:25:00	SPY	ETF	159.84	159.84	159.84	159.84	100.0
2013-05-01 06:30:00	SPY	ETF	159.82	159.83	159.82	159.83	600.0
2013-05-01 06:40:00	SPY	ETF	159.82	159.82	159.82	159.82	200.0
2013-05-01 06:45:00	SPY	ETF	159.86	159.9	159.86	159.9	11476.0
2013-05-01 06:50:00	SPY	ETF	159.93	159.93	159.91	159.93	15300.0
2013-05-01 06:55:00	SPY	ETF	159.92	159.92	159.9	159.92	900.0
2013-05-01 07:00:00	SPY	ETF	159.93	159.96	159.9	159.9	33500.0
2013-05-01 07:05:00	SPY	ETF	159.9	159.91	159.85	159.86	5356.0
2013-05-01 07:10:00	SPY	ETF	159.85	159.85	159.83	159.83	1000.0
2013-05-01 07:15:00	SPY	ETF	159.84	159.88	159.83	159.88	400.0
2013-05-01 07:20:00	SPY	ETF	159.82	159.82	159.82	159.82	19999.0
2013-05-01 07:25:00	SPY	ETF	159.85	159.86	159.85	159.86	300.0
2013-05-01 07:30:00	SPY	ETF	159.85	159.85	159.85	159.85	7700.0
2013-05-01 07:35:00	SPY	ETF	159.85	159.88	159.85	159.88	3620.0
2013-05-01 07:40:00	SPY	ETF	159.89	159.93	159.88	159.9	5500.0
2013-05-01 07:45:00	SPY	ETF	159.92	159.96	159.92	159.95	21700.0
2013-05-01 07:50:00	SPY	ETF	159.95	160.0	159.88	159.88	5500.0
2013-05-01 07:55:00	SPY	ETF	159.88	159.88	159.83	159.83	4100.0
2013-05-01 08:00:00	SPY	ETF	159.85	160.08	159.82	159.85	28892.0
2013-05-01 08:05:00	SPY	ETF	159.83	159.85	159.75	159.85	250824.0
2013-05-01 08:10:00	SPY	ETF	159.83	159.86	159.82	159.85	124738.0
2013-05-01 08:15:00	SPY	ETF	159.8	159.8	159.42	159.72	187262.0
2013-05-01 08:20:00	SPY	ETF	159.74	159.76	159.71	159.75	102652.0
2013-05-01 08:25:00	SPY	ETF	159.74	159.75	159.74	159.74	17170.0
2013-05-01 08:30:00	SPY	ETF	159.75	159.75	159.64	159.64	70536.0
2013-05-01 08:35:00	SPY	ETF	159.65	159.73	159.64	159.72	105301.0
2013-05-01 08:40:00	SPY	ETF	159.7	159.7	159.57	159.57	356171.0
2013-05-01 08:45:00	SPY	ETF	159.58	159.62	159.52	159.53	233752.0
2013-05-01 08:50:00	SPY	ETF	159.54	159.57	159.51	159.52	140980.0
2013-05-01 08:55:00	SPY	ETF	159.52	159.55	159.44	159.48	103224.0
2013-05-01 09:00:00	SPY	ETF	159.5	159.5	159.4	159.43	150773.0
2013-05-01 09:05:00	SPY	ETF	159.42	159.44	159.35	159.37	84385.0
2013-05-01 09:10:00	SPY	ETF	159.37	159.43	159.35	159.39	127742.0
2013-05-01 09:15:00	SPY	ETF	159.39	159.42	159.34	159.39	111611.0
2013-05-01 09:20:00	SPY	ETF	159.39	159.68	159.31	159.37	171236.0
2013-05-01 09:25:00	SPY	ETF	159.39	159.4	159.29	159.33	309379.0
2013-05-01 09:30:00	SPY	ETF	159.33	159.37	159.23	159.24	3000979.0
2013-05-01 09:35:00	SPY	ETF	159.24	159.27	159.11	159.25	2036072.0
2013-05-01 09:40:00	SPY	ETF	159.25	159.36	159.13	159.35	1858268.0

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

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