PREVIEW / etf_5min / 2013-09-06

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-09-06.parquet
  size:    958 KB
  rows:    40,452

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-09-06 04:10:00	SPY	ETF	165.88	165.88	165.88	165.88	600.0
2013-09-06 04:15:00	SPY	ETF	165.9	165.9	165.88	165.88	1200.0
2013-09-06 04:30:00	SPY	ETF	165.9	165.96	165.9	165.96	1600.0
2013-09-06 04:35:00	SPY	ETF	165.94	165.94	165.94	165.94	600.0
2013-09-06 04:40:00	SPY	ETF	165.9	165.9	165.88	165.88	1000.0
2013-09-06 04:50:00	SPY	ETF	165.9	165.9	165.9	165.9	600.0
2013-09-06 04:55:00	SPY	ETF	165.92	165.96	165.92	165.96	1000.0
2013-09-06 05:00:00	SPY	ETF	165.94	165.94	165.94	165.94	600.0
2013-09-06 05:05:00	SPY	ETF	165.9	165.9	165.9	165.9	400.0
2013-09-06 05:10:00	SPY	ETF	165.92	165.96	165.9	165.9	2000.0
2013-09-06 05:25:00	SPY	ETF	165.92	165.92	165.92	165.92	400.0
2013-09-06 05:40:00	SPY	ETF	165.9	165.9	165.88	165.88	1000.0
2013-09-06 05:45:00	SPY	ETF	165.9	165.9	165.9	165.9	600.0
2013-09-06 05:50:00	SPY	ETF	165.88	165.88	165.86	165.86	900.0
2013-09-06 06:00:00	SPY	ETF	165.83	165.83	165.82	165.82	400.0
2013-09-06 06:05:00	SPY	ETF	165.81	165.85	165.81	165.85	500.0
2013-09-06 06:15:00	SPY	ETF	165.81	165.81	165.81	165.81	900.0
2013-09-06 06:25:00	SPY	ETF	165.82	165.84	165.82	165.84	200.0
2013-09-06 06:35:00	SPY	ETF	165.9	165.9	165.9	165.9	10000.0
2013-09-06 06:45:00	SPY	ETF	165.89	165.89	165.89	165.89	400.0
2013-09-06 06:55:00	SPY	ETF	165.92	165.92	165.92	165.92	400.0
2013-09-06 07:00:00	SPY	ETF	165.91	165.91	165.91	165.91	900.0
2013-09-06 07:05:00	SPY	ETF	165.94	165.94	165.94	165.94	900.0
2013-09-06 07:10:00	SPY	ETF	165.96	165.96	165.96	165.96	600.0
2013-09-06 07:15:00	SPY	ETF	166.0	166.11	166.0	166.1	14715.0
2013-09-06 07:20:00	SPY	ETF	166.07	166.09	166.06	166.06	1300.0
2013-09-06 07:25:00	SPY	ETF	166.02	166.1	166.02	166.1	11760.0
2013-09-06 07:30:00	SPY	ETF	166.11	166.16	166.11	166.14	4200.0
2013-09-06 07:35:00	SPY	ETF	166.14	166.16	166.14	166.16	6300.0
2013-09-06 07:40:00	SPY	ETF	166.18	166.18	166.14	166.17	3390.0
2013-09-06 07:45:00	SPY	ETF	166.18	166.2	166.14	166.14	2154.0
2013-09-06 07:50:00	SPY	ETF	166.18	166.2	166.1	166.12	17350.0
2013-09-06 07:55:00	SPY	ETF	166.15	166.23	166.14	166.22	77679.0
2013-09-06 08:00:00	SPY	ETF	166.21	166.38	165.99	166.27	80325.0
2013-09-06 08:05:00	SPY	ETF	166.3	166.5	166.29	166.47	93680.0
2013-09-06 08:10:00	SPY	ETF	166.46	166.48	166.42	166.47	96385.0
2013-09-06 08:15:00	SPY	ETF	166.45	166.48	166.44	166.47	132600.0
2013-09-06 08:20:00	SPY	ETF	166.44	166.52	166.44	166.49	116066.0
2013-09-06 08:25:00	SPY	ETF	166.49	166.53	166.0	166.5	320335.0
2013-09-06 08:30:00	SPY	ETF	166.51	166.94	165.82	166.61	2532178.0
2013-09-06 08:35:00	SPY	ETF	166.61	166.8	166.43	166.52	825863.0
2013-09-06 08:40:00	SPY	ETF	166.53	166.64	166.46	166.48	162832.0
2013-09-06 08:45:00	SPY	ETF	166.48	166.7	166.47	166.6	176751.0
2013-09-06 08:50:00	SPY	ETF	166.61	166.85	166.61	166.78	317834.0
2013-09-06 08:55:00	SPY	ETF	166.77	166.84	166.75	166.83	139402.0
2013-09-06 09:00:00	SPY	ETF	166.83	166.85	166.68	166.71	263672.0
2013-09-06 09:05:00	SPY	ETF	166.71	166.73	166.59	166.63	296065.0
2013-09-06 09:10:00	SPY	ETF	166.63	166.65	166.56	166.58	219584.0
2013-09-06 09:15:00	SPY	ETF	166.58	166.64	166.51	166.55	220256.0
2013-09-06 09:20:00	SPY	ETF	166.55	166.66	166.55	166.61	248857.0

> showing 50 of 40,452 rows — these rows as CSV

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