PREVIEW / etf_5min / 2012-04-17

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-17.parquet
  size:    856 KB
  rows:    35,926

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
2012-04-17 04:00:00	SPY	ETF	137.23	137.29	137.23	137.23	1800.0
2012-04-17 04:05:00	SPY	ETF	137.2	137.2	137.2	137.2	500.0
2012-04-17 04:20:00	SPY	ETF	137.17	137.17	137.17	137.17	500.0
2012-04-17 04:25:00	SPY	ETF	137.2	137.26	137.2	137.26	1400.0
2012-04-17 04:30:00	SPY	ETF	137.29	137.32	137.29	137.32	800.0
2012-04-17 04:35:00	SPY	ETF	137.32	137.35	137.32	137.35	700.0
2012-04-17 04:40:00	SPY	ETF	137.38	137.39	137.38	137.39	1000.0
2012-04-17 04:45:00	SPY	ETF	137.41	137.44	137.41	137.44	1000.0
2012-04-17 04:55:00	SPY	ETF	137.38	137.46	137.38	137.46	1100.0
2012-04-17 05:00:00	SPY	ETF	137.47	137.62	137.47	137.62	3900.0
2012-04-17 05:05:00	SPY	ETF	137.65	137.65	137.65	137.65	100.0
2012-04-17 05:10:00	SPY	ETF	137.59	137.59	137.59	137.59	400.0
2012-04-17 05:15:00	SPY	ETF	137.58	137.58	137.53	137.57	5700.0
2012-04-17 05:20:00	SPY	ETF	137.53	137.53	137.5	137.5	1000.0
2012-04-17 05:25:00	SPY	ETF	137.52	137.52	137.52	137.52	200.0
2012-04-17 05:30:00	SPY	ETF	137.54	137.59	137.54	137.59	6300.0
2012-04-17 05:35:00	SPY	ETF	137.59	137.64	137.59	137.64	1850.0
2012-04-17 05:40:00	SPY	ETF	137.64	137.64	137.64	137.64	1000.0
2012-04-17 05:45:00	SPY	ETF	137.64	137.71	137.64	137.68	20500.0
2012-04-17 05:50:00	SPY	ETF	137.62	137.62	137.56	137.56	2200.0
2012-04-17 05:55:00	SPY	ETF	137.53	137.53	137.44	137.44	12200.0
2012-04-17 06:00:00	SPY	ETF	137.45	137.45	137.44	137.44	1000.0
2012-04-17 06:10:00	SPY	ETF	137.5	137.52	137.5	137.52	10000.0
2012-04-17 06:15:00	SPY	ETF	137.53	137.53	137.53	137.53	500.0
2012-04-17 06:25:00	SPY	ETF	137.5	137.5	137.5	137.5	35000.0
2012-04-17 06:30:00	SPY	ETF	137.56	137.67	137.56	137.66	40000.0
2012-04-17 06:35:00	SPY	ETF	137.64	137.68	137.59	137.64	61390.0
2012-04-17 06:40:00	SPY	ETF	137.64	137.77	137.64	137.77	35300.0
2012-04-17 06:45:00	SPY	ETF	137.75	137.78	137.67	137.67	4340.0
2012-04-17 06:50:00	SPY	ETF	137.66	137.66	137.65	137.66	900.0
2012-04-17 06:55:00	SPY	ETF	137.62	137.66	137.62	137.66	7200.0
2012-04-17 07:00:00	SPY	ETF	137.62	137.62	137.6	137.62	24942.0
2012-04-17 07:05:00	SPY	ETF	137.63	137.72	137.63	137.7	22050.0
2012-04-17 07:10:00	SPY	ETF	137.71	137.77	137.7	137.7	28100.0
2012-04-17 07:15:00	SPY	ETF	137.74	137.77	137.72	137.74	3132.0
2012-04-17 07:20:00	SPY	ETF	137.74	137.76	137.73	137.75	6500.0
2012-04-17 07:25:00	SPY	ETF	137.77	137.85	137.77	137.8	199600.0
2012-04-17 07:30:00	SPY	ETF	137.81	137.83	137.77	137.77	247500.0
2012-04-17 07:35:00	SPY	ETF	137.77	137.77	137.71	137.71	30800.0
2012-04-17 07:40:00	SPY	ETF	137.69	137.71	137.65	137.69	19000.0
2012-04-17 07:45:00	SPY	ETF	137.67	137.72	137.66	137.7	26735.0
2012-04-17 07:50:00	SPY	ETF	137.7	137.7	137.57	137.59	12558.0
2012-04-17 07:55:00	SPY	ETF	137.58	137.6	137.54	137.59	40486.0
2012-04-17 08:00:00	SPY	ETF	137.6	137.73	136.975	137.6	463353.0
2012-04-17 08:05:00	SPY	ETF	137.78	137.78	137.57	137.57	201448.0
2012-04-17 08:10:00	SPY	ETF	137.57	137.64	137.57	137.62	48900.0
2012-04-17 08:15:00	SPY	ETF	137.63	137.66	137.61	137.63	73100.0
2012-04-17 08:20:00	SPY	ETF	137.62	137.73	137.61	137.71	101216.0
2012-04-17 08:25:00	SPY	ETF	137.71	137.74	137.68	137.69	52601.0
2012-04-17 08:30:00	SPY	ETF	137.66	137.68	137.5	137.57	240315.0

> showing 50 of 35,926 rows — these rows as CSV

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