PREVIEW / etf_5min / 2013-01-08

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-08.parquet
  size:    913 KB
  rows:    39,305

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-01-08 04:10:00	SPY	ETF	145.63	145.63	145.63	145.63	100.0
2013-01-08 04:15:00	SPY	ETF	145.63	145.63	145.63	145.63	400.0
2013-01-08 05:00:00	SPY	ETF	145.69	145.69	145.69	145.69	1300.0
2013-01-08 05:05:00	SPY	ETF	145.63	145.63	145.59	145.59	9500.0
2013-01-08 05:20:00	SPY	ETF	145.65	145.65	145.65	145.65	5000.0
2013-01-08 05:25:00	SPY	ETF	145.67	145.67	145.67	145.67	500.0
2013-01-08 05:35:00	SPY	ETF	145.69	145.69	145.69	145.69	18800.0
2013-01-08 05:40:00	SPY	ETF	145.77	145.82	145.76	145.81	3000.0
2013-01-08 05:45:00	SPY	ETF	145.82	145.83	145.82	145.83	11000.0
2013-01-08 05:50:00	SPY	ETF	145.84	145.84	145.84	145.84	500.0
2013-01-08 06:00:00	SPY	ETF	145.85	145.85	145.85	145.85	200.0
2013-01-08 06:05:00	SPY	ETF	145.78	145.78	145.76	145.76	400.0
2013-01-08 06:25:00	SPY	ETF	145.85	145.86	145.85	145.86	2900.0
2013-01-08 06:30:00	SPY	ETF	145.86	145.86	145.84	145.84	1500.0
2013-01-08 06:35:00	SPY	ETF	145.86	145.92	145.86	145.92	1500.0
2013-01-08 06:40:00	SPY	ETF	145.95	145.95	145.95	145.95	11605.0
2013-01-08 06:45:00	SPY	ETF	145.97	145.97	145.97	145.97	10200.0
2013-01-08 06:50:00	SPY	ETF	145.96	145.97	145.96	145.97	11600.0
2013-01-08 06:55:00	SPY	ETF	145.98	145.99	145.94	145.94	57900.0
2013-01-08 07:00:00	SPY	ETF	145.94	145.94	145.9	145.9	900.0
2013-01-08 07:05:00	SPY	ETF	145.89	145.89	145.87	145.87	400.0
2013-01-08 07:10:00	SPY	ETF	145.9	145.96	145.87	145.96	17614.0
2013-01-08 07:15:00	SPY	ETF	145.97	145.97	145.94	145.96	9258.0
2013-01-08 07:20:00	SPY	ETF	145.93	145.95	145.88	145.89	3600.0
2013-01-08 07:25:00	SPY	ETF	145.88	145.88	145.87	145.87	600.0
2013-01-08 07:30:00	SPY	ETF	145.85	145.87	145.85	145.87	5750.0
2013-01-08 07:35:00	SPY	ETF	145.85	145.85	145.85	145.85	1200.0
2013-01-08 07:40:00	SPY	ETF	145.85	145.87	145.83	145.83	12500.0
2013-01-08 07:45:00	SPY	ETF	145.85	145.87	145.71	145.74	58325.0
2013-01-08 07:50:00	SPY	ETF	145.76	145.79	145.74	145.75	10503.0
2013-01-08 07:55:00	SPY	ETF	145.71	145.78	145.71	145.78	7000.0
2013-01-08 08:00:00	SPY	ETF	145.79	145.87	145.74	145.74	31204.0
2013-01-08 08:05:00	SPY	ETF	145.75	145.76	145.71	145.74	135791.0
2013-01-08 08:10:00	SPY	ETF	145.72	145.76	145.71	145.74	66260.0
2013-01-08 08:15:00	SPY	ETF	145.73	145.8	145.7	145.8	45896.0
2013-01-08 08:20:00	SPY	ETF	145.77	145.78	145.73	145.76	11600.0
2013-01-08 08:25:00	SPY	ETF	145.77	145.78	145.75	145.75	4500.0
2013-01-08 08:30:00	SPY	ETF	145.75	145.82	145.74	145.81	20300.0
2013-01-08 08:35:00	SPY	ETF	145.8	145.84	145.79	145.83	15300.0
2013-01-08 08:40:00	SPY	ETF	145.85	145.85	145.59	145.62	72876.0
2013-01-08 08:45:00	SPY	ETF	145.63	145.7	145.62	145.7	54786.0
2013-01-08 08:50:00	SPY	ETF	145.7	145.7	145.64	145.66	62793.0
2013-01-08 08:55:00	SPY	ETF	145.66	145.71	145.66	145.66	36439.0
2013-01-08 09:00:00	SPY	ETF	145.65	145.66	145.59	145.64	75587.0
2013-01-08 09:05:00	SPY	ETF	145.64	145.65	145.6	145.63	80241.0
2013-01-08 09:10:00	SPY	ETF	145.63	145.72	145.55	145.72	252599.0
2013-01-08 09:15:00	SPY	ETF	145.7	145.7	145.65	145.67	70200.0
2013-01-08 09:20:00	SPY	ETF	145.66	145.68	145.65	145.68	44400.0
2013-01-08 09:25:00	SPY	ETF	145.67	145.72	145.64	145.71	102167.0
2013-01-08 09:30:00	SPY	ETF	145.71	145.82	145.65	145.7	2710761.0

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

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