PREVIEW / etf_5min / 2013-04-05

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-05.parquet
  size:    1015 KB
  rows:    42,515

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-04-05 04:00:00	SPY	ETF	155.65	155.65	155.61	155.61	10600.0
2013-04-05 04:35:00	SPY	ETF	155.63	155.63	155.61	155.61	10000.0
2013-04-05 04:45:00	SPY	ETF	155.63	155.63	155.58	155.58	800.0
2013-04-05 04:50:00	SPY	ETF	155.56	155.56	155.56	155.56	100.0
2013-04-05 05:05:00	SPY	ETF	155.58	155.58	155.58	155.58	10000.0
2013-04-05 05:10:00	SPY	ETF	155.57	155.57	155.52	155.52	5260.0
2013-04-05 05:15:00	SPY	ETF	155.59	155.59	155.59	155.59	500.0
2013-04-05 05:20:00	SPY	ETF	155.5	155.5	155.46	155.46	4400.0
2013-04-05 05:25:00	SPY	ETF	155.52	155.52	155.52	155.52	600.0
2013-04-05 05:30:00	SPY	ETF	155.55	155.55	155.55	155.55	400.0
2013-04-05 05:45:00	SPY	ETF	155.4	155.4	155.38	155.4	2400.0
2013-04-05 05:50:00	SPY	ETF	155.37	155.37	155.24	155.3	26950.0
2013-04-05 05:55:00	SPY	ETF	155.3	155.35	155.3	155.33	3750.0
2013-04-05 06:00:00	SPY	ETF	155.41	155.42	155.41	155.42	1300.0
2013-04-05 06:05:00	SPY	ETF	155.42	155.42	155.38	155.38	1900.0
2013-04-05 06:10:00	SPY	ETF	155.38	155.38	155.38	155.38	300.0
2013-04-05 06:15:00	SPY	ETF	155.33	155.33	155.21	155.21	2200.0
2013-04-05 06:20:00	SPY	ETF	155.22	155.24	155.22	155.24	1600.0
2013-04-05 06:25:00	SPY	ETF	155.28	155.28	155.25	155.25	1800.0
2013-04-05 06:30:00	SPY	ETF	155.22	155.23	155.19	155.19	16240.0
2013-04-05 06:35:00	SPY	ETF	155.2	155.2	155.08	155.13	30695.0
2013-04-05 06:40:00	SPY	ETF	155.1	155.13	155.03	155.09	12120.0
2013-04-05 06:45:00	SPY	ETF	155.09	155.11	155.05	155.05	23800.0
2013-04-05 06:50:00	SPY	ETF	155.05	155.1	155.04	155.09	9500.0
2013-04-05 06:55:00	SPY	ETF	155.13	155.13	155.02	155.03	34400.0
2013-04-05 07:00:00	SPY	ETF	155.07	155.13	155.07	155.1	71680.0
2013-04-05 07:05:00	SPY	ETF	155.1	155.11	155.06	155.09	97910.0
2013-04-05 07:10:00	SPY	ETF	155.09	155.11	155.03	155.04	18350.0
2013-04-05 07:15:00	SPY	ETF	155.03	155.03	154.84	154.9	125490.0
2013-04-05 07:20:00	SPY	ETF	154.91	154.93	154.85	154.9	51299.0
2013-04-05 07:25:00	SPY	ETF	154.9	154.94	154.9	154.91	43500.0
2013-04-05 07:30:00	SPY	ETF	154.92	154.93	154.9	154.91	2300.0
2013-04-05 07:35:00	SPY	ETF	154.93	154.96	154.92	154.93	24700.0
2013-04-05 07:40:00	SPY	ETF	154.93	154.93	154.76	154.84	172475.0
2013-04-05 07:45:00	SPY	ETF	154.87	154.99	154.85	154.99	179580.0
2013-04-05 07:50:00	SPY	ETF	154.99	155.05	154.96	155.03	88345.0
2013-04-05 07:55:00	SPY	ETF	155.01	155.04	154.98	154.98	68212.0
2013-04-05 08:00:00	SPY	ETF	155.01	155.8	154.83	154.93	143758.0
2013-04-05 08:05:00	SPY	ETF	154.92	155.0	154.9	154.94	116655.0
2013-04-05 08:10:00	SPY	ETF	154.93	155.0	154.93	154.98	161890.0
2013-04-05 08:15:00	SPY	ETF	154.98	155.04	154.98	154.99	140194.0
2013-04-05 08:20:00	SPY	ETF	154.99	155.03	154.93	154.94	209513.0
2013-04-05 08:25:00	SPY	ETF	154.94	154.97	154.86	154.91	290595.0
2013-04-05 08:30:00	SPY	ETF	154.91	154.92	153.85	153.98	3653152.0
2013-04-05 08:35:00	SPY	ETF	153.98	154.32	153.98	154.32	1072732.0
2013-04-05 08:40:00	SPY	ETF	154.32	155.05	154.15	154.35	573979.0
2013-04-05 08:45:00	SPY	ETF	154.34	154.37	154.01	154.03	454750.0
2013-04-05 08:50:00	SPY	ETF	154.04	154.09	153.95	153.98	590101.0
2013-04-05 08:55:00	SPY	ETF	153.99	154.0	153.78	153.93	420640.0
2013-04-05 09:00:00	SPY	ETF	153.92	154.0	153.87	153.87	262866.0

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

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