PREVIEW / etf_1hour / 2012-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-10.parquet
  size:    184 KB
  rows:    5,802

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-10 04:00:00	SPY	ETF	128.59	129.19	128.59	128.98	5262.0
2012-01-10 05:00:00	SPY	ETF	128.95	129.2	128.95	129.13	24240.0
2012-01-10 06:00:00	SPY	ETF	129.2	129.35	129.12	129.18	179970.0
2012-01-10 07:00:00	SPY	ETF	129.16	129.34	129.07	129.31	565756.0
2012-01-10 08:00:00	SPY	ETF	129.29	129.47	129.14	129.34	2149366.0
2012-01-10 09:00:00	SPY	ETF	129.35	129.5	129.15	129.34	17857908.0
2012-01-10 10:00:00	SPY	ETF	129.34	129.65	129.29	129.4101	20389013.0
2012-01-10 11:00:00	SPY	ETF	129.41	129.51	129.2	129.33	14412037.0
2012-01-10 12:00:00	SPY	ETF	129.32	129.36	128.95	129.13	10454873.0
2012-01-10 13:00:00	SPY	ETF	129.13	129.36	128.9728	129.15	9578303.0
2012-01-10 14:00:00	SPY	ETF	129.1575	129.36	129.07	129.28	9556957.0
2012-01-10 15:00:00	SPY	ETF	129.28	129.32	128.97	129.16	23668424.0
2012-01-10 16:00:00	SPY	ETF	129.16	129.1805	128.88	128.96	5093392.0
2012-01-10 17:00:00	SPY	ETF	128.96	129.07	128.8	128.91	358536.0
2012-01-10 18:00:00	SPY	ETF	128.89	129.13	128.87	128.89	446954.0
2012-01-10 19:00:00	SPY	ETF	128.89	128.92	128.76	128.79	156048.0
2012-01-10 04:00:00	QQQ	ETF	58.04	58.05	58.04	58.05	350.0
2012-01-10 05:00:00	QQQ	ETF	58.17	58.21	58.17	58.21	7300.0
2012-01-10 06:00:00	QQQ	ETF	58.14	58.17	58.14	58.17	700.0
2012-01-10 07:00:00	QQQ	ETF	58.15	58.19	58.08	58.17	141460.0
2012-01-10 08:00:00	QQQ	ETF	58.18	58.22	58.15	58.21	235825.0
2012-01-10 09:00:00	QQQ	ETF	58.21	58.34	58.18	58.27	5205887.0
2012-01-10 10:00:00	QQQ	ETF	58.27	58.405	58.13	58.21	6059691.0
2012-01-10 11:00:00	QQQ	ETF	58.2	58.24	58.1	58.13	3681334.0
2012-01-10 12:00:00	QQQ	ETF	58.12	58.15	57.89	58.05	3582811.0
2012-01-10 13:00:00	QQQ	ETF	58.05	58.11	57.93	58.08	2489409.0
2012-01-10 14:00:00	QQQ	ETF	58.08	58.19	58.02	58.16	3550841.0
2012-01-10 15:00:00	QQQ	ETF	58.16	58.17	57.98	58.03	6261898.0
2012-01-10 16:00:00	QQQ	ETF	58.03	58.09	57.88	57.94	1027335.0
2012-01-10 17:00:00	QQQ	ETF	57.95	57.97	57.86	57.9	424900.0
2012-01-10 18:00:00	QQQ	ETF	57.91	57.92	57.88	57.88	11800.0
2012-01-10 19:00:00	QQQ	ETF	57.9	57.9	57.83	57.84	57590.0
2012-01-10 04:00:00	IWM	ETF	75.72	75.72	75.72	75.72	100.0
2012-01-10 06:00:00	IWM	ETF	76.0	76.15	76.0	76.15	51400.0
2012-01-10 07:00:00	IWM	ETF	76.0	76.15	75.9	76.13	96802.0
2012-01-10 08:00:00	IWM	ETF	76.13	76.23	76.09	76.15	362996.0
2012-01-10 09:00:00	IWM	ETF	76.16	76.33	76.02	76.2	4397865.0
2012-01-10 10:00:00	IWM	ETF	76.22	76.391	76.16	76.32	6471208.0
2012-01-10 11:00:00	IWM	ETF	76.31	76.43	76.2	76.35	3360250.0
2012-01-10 12:00:00	IWM	ETF	76.35	76.36	75.96	76.171	4317493.0
2012-01-10 13:00:00	IWM	ETF	76.18	76.26	76.035	76.165	2865438.0
2012-01-10 14:00:00	IWM	ETF	76.169	76.36	76.1	76.305	3976939.0
2012-01-10 15:00:00	IWM	ETF	76.31	76.36	76.075	76.27	5873234.0
2012-01-10 16:00:00	IWM	ETF	76.27	76.35	76.16	76.18	1198723.0
2012-01-10 17:00:00	IWM	ETF	76.17	76.2	76.09	76.1	80099.0
2012-01-10 18:00:00	IWM	ETF	76.1	76.12	76.1	76.12	4462.0
2012-01-10 19:00:00	IWM	ETF	76.11	76.11	75.99	75.99	22073.0
2012-01-10 07:00:00	DIA	ETF	124.66	125.0	124.66	125.0	3365.0
2012-01-10 08:00:00	DIA	ETF	124.53	125.12	124.53	124.88	73921.0
2012-01-10 09:00:00	DIA	ETF	124.9	124.97	124.57	124.77	737634.0

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

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