PREVIEW / etf_1hour / 2012-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-24.parquet
  size:    186 KB
  rows:    5,756

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-01-24 04:00:00	SPY	ETF	131.2	131.2	130.96	131.01	3200.0
2012-01-24 05:00:00	SPY	ETF	130.96	131.09	130.85	130.87	57300.0
2012-01-24 06:00:00	SPY	ETF	130.85	130.95	130.7	130.73	129915.0
2012-01-24 07:00:00	SPY	ETF	130.74	131.05	130.74	130.86	411339.0
2012-01-24 08:00:00	SPY	ETF	130.87	130.99	130.67	130.75	1193157.0
2012-01-24 09:00:00	SPY	ETF	130.74	130.94	130.6	130.8	16695548.0
2012-01-24 10:00:00	SPY	ETF	130.8	131.3	130.72	131.19	20773112.0
2012-01-24 11:00:00	SPY	ETF	131.1807	131.41	131.11	131.22	12039549.0
2012-01-24 12:00:00	SPY	ETF	131.22	131.4	131.2	131.36	6974421.0
2012-01-24 13:00:00	SPY	ETF	131.37	131.38	131.1	131.2698	8822473.0
2012-01-24 14:00:00	SPY	ETF	131.27	131.46	131.24	131.32	9742383.0
2012-01-24 15:00:00	SPY	ETF	131.32	131.5	131.29	131.46	19021024.0
2012-01-24 16:00:00	SPY	ETF	131.465	132.09	130.83	131.91	5778062.0
2012-01-24 17:00:00	SPY	ETF	131.92	132.03	131.9	132.0	354235.0
2012-01-24 18:00:00	SPY	ETF	131.98	131.99	131.46	131.86	177753.0
2012-01-24 19:00:00	SPY	ETF	131.86	132.01	131.85	132.0	213614.0
2012-01-24 04:00:00	QQQ	ETF	59.77	59.77	59.77	59.77	224.0
2012-01-24 06:00:00	QQQ	ETF	59.77	59.83	59.49	59.59	45880.0
2012-01-24 07:00:00	QQQ	ETF	59.5	59.62	59.5	59.55	47500.0
2012-01-24 08:00:00	QQQ	ETF	59.57	59.59	59.48	59.49	191292.0
2012-01-24 09:00:00	QQQ	ETF	59.49	59.59	59.41	59.49	5906629.0
2012-01-24 10:00:00	QQQ	ETF	59.49	59.84	59.44	59.74	8305094.0
2012-01-24 11:00:00	QQQ	ETF	59.75	59.84	59.67	59.69	3498974.0
2012-01-24 12:00:00	QQQ	ETF	59.69	59.78	59.63	59.71	1861209.0
2012-01-24 13:00:00	QQQ	ETF	59.71	59.71	59.53	59.65	2153119.0
2012-01-24 14:00:00	QQQ	ETF	59.65	59.73	59.62	59.65	2225115.0
2012-01-24 15:00:00	QQQ	ETF	59.65	59.74	59.56	59.68	5885205.0
2012-01-24 16:00:00	QQQ	ETF	59.67	60.61	59.6138	60.45	6845137.0
2012-01-24 17:00:00	QQQ	ETF	60.46	60.52	60.41	60.45	570069.0
2012-01-24 18:00:00	QQQ	ETF	60.5	60.5	60.41	60.43	147791.0
2012-01-24 19:00:00	QQQ	ETF	60.44	60.46	60.41	60.44	45469.0
2012-01-24 06:00:00	IWM	ETF	77.66	77.68	77.59	77.59	1800.0
2012-01-24 07:00:00	IWM	ETF	77.61	77.81	77.6	77.6	17340.0
2012-01-24 08:00:00	IWM	ETF	77.7	77.8	77.54	77.64	211807.0
2012-01-24 09:00:00	IWM	ETF	77.64	77.75	77.27	77.57	5595112.0
2012-01-24 10:00:00	IWM	ETF	77.56	78.21	77.54	78.1	7347738.0
2012-01-24 11:00:00	IWM	ETF	78.11	78.43	78.07	78.21	4344250.0
2012-01-24 12:00:00	IWM	ETF	78.21	78.48	78.2	78.44	3151710.0
2012-01-24 13:00:00	IWM	ETF	78.45	78.46	78.28	78.397	3001821.0
2012-01-24 14:00:00	IWM	ETF	78.4	78.57	78.38	78.51	3302174.0
2012-01-24 15:00:00	IWM	ETF	78.51	78.75	78.48	78.61	7116090.0
2012-01-24 16:00:00	IWM	ETF	78.62	79.17	78.15	79.02	4140634.0
2012-01-24 17:00:00	IWM	ETF	79.03	79.12	79.01	79.1	132198.0
2012-01-24 18:00:00	IWM	ETF	79.15	79.15	79.01	79.01	1530.0
2012-01-24 19:00:00	IWM	ETF	79.0	79.1	79.0	79.1	2515.0
2012-01-24 06:00:00	DIA	ETF	126.19	126.19	126.19	126.19	500.0
2012-01-24 07:00:00	DIA	ETF	126.21	126.46	126.19	126.26	1900.0
2012-01-24 08:00:00	DIA	ETF	126.25	126.3	126.17	126.17	3800.0
2012-01-24 09:00:00	DIA	ETF	126.13	126.21	125.87	126.0	820200.0
2012-01-24 10:00:00	DIA	ETF	125.99	126.51	125.89	126.37	1101413.0

> showing 50 of 5,756 rows — these rows as CSV

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