PREVIEW / etf_1hour / 2012-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-02.parquet
  size:    186 KB
  rows:    5,763

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-02-02 04:00:00	SPY	ETF	132.5	132.5	132.32	132.33	81064.0
2012-02-02 05:00:00	SPY	ETF	132.48	132.67	132.38	132.54	48500.0
2012-02-02 06:00:00	SPY	ETF	132.46	132.6	132.44	132.49	23550.0
2012-02-02 07:00:00	SPY	ETF	137.0	137.0	132.17	132.26	332026.0
2012-02-02 08:00:00	SPY	ETF	132.29	132.64	132.22	132.57	1328845.0
2012-02-02 09:00:00	SPY	ETF	132.57	132.8	132.37	132.61	16796909.0
2012-02-02 10:00:00	SPY	ETF	132.62	133.02	132.61	132.88	18468202.0
2012-02-02 11:00:00	SPY	ETF	132.88	132.99	132.49	132.59	15378901.0
2012-02-02 12:00:00	SPY	ETF	132.58	132.64	132.21	132.5	12483634.0
2012-02-02 13:00:00	SPY	ETF	132.51	132.7	132.4	132.6389	9994049.0
2012-02-02 14:00:00	SPY	ETF	132.635	132.73	132.52	132.635	9794636.0
2012-02-02 15:00:00	SPY	ETF	132.634	132.83	132.59	132.67	18981841.0
2012-02-02 16:00:00	SPY	ETF	132.69	132.86	132.6496	132.75	6420431.0
2012-02-02 17:00:00	SPY	ETF	132.73	132.77	132.621	132.72	251403.0
2012-02-02 18:00:00	SPY	ETF	132.72	132.79	132.67	132.71	77988.0
2012-02-02 19:00:00	SPY	ETF	132.71	132.8	132.67	132.8	102522.0
2012-02-02 04:00:00	QQQ	ETF	61.03	61.03	61.03	61.03	700.0
2012-02-02 05:00:00	QQQ	ETF	61.17	61.17	61.07	61.07	500.0
2012-02-02 06:00:00	QQQ	ETF	61.09	61.09	61.07	61.07	1547.0
2012-02-02 07:00:00	QQQ	ETF	61.05	61.06	60.89	60.99	208885.0
2012-02-02 08:00:00	QQQ	ETF	61.01	61.17	60.98	61.15	142430.0
2012-02-02 09:00:00	QQQ	ETF	61.14	61.24	61.12	61.226	4155917.0
2012-02-02 10:00:00	QQQ	ETF	61.222	61.41	61.21	61.35	6540812.0
2012-02-02 11:00:00	QQQ	ETF	61.35	61.41	61.16	61.2326	5672445.0
2012-02-02 12:00:00	QQQ	ETF	61.24	61.252	60.97	61.12	3577709.0
2012-02-02 13:00:00	QQQ	ETF	61.12	61.17	61.02	61.12	4140846.0
2012-02-02 14:00:00	QQQ	ETF	61.12	61.21	61.11	61.17	3779805.0
2012-02-02 15:00:00	QQQ	ETF	61.17	61.27	61.15	61.21	6650966.0
2012-02-02 16:00:00	QQQ	ETF	61.21	61.23	61.16	61.19	1017385.0
2012-02-02 17:00:00	QQQ	ETF	61.22	61.24	61.2	61.21	13230.0
2012-02-02 18:00:00	QQQ	ETF	61.2	61.21	61.19	61.21	23833.0
2012-02-02 19:00:00	QQQ	ETF	61.2	61.23	61.19	61.23	6900.0
2012-02-02 04:00:00	IWM	ETF	80.75	80.75	80.75	80.75	129.0
2012-02-02 06:00:00	IWM	ETF	80.98	81.0	80.94	80.94	16126.0
2012-02-02 07:00:00	IWM	ETF	80.86	80.86	80.65	80.72	98400.0
2012-02-02 08:00:00	IWM	ETF	80.69	80.92	80.66	80.89	253318.0
2012-02-02 09:00:00	IWM	ETF	80.89	81.07	80.74	81.01	5008853.0
2012-02-02 10:00:00	IWM	ETF	81.02	81.49	80.93	81.41	7715738.0
2012-02-02 11:00:00	IWM	ETF	81.42	81.53	81.08	81.2	5726379.0
2012-02-02 12:00:00	IWM	ETF	81.2	81.24	80.875	81.08	4346038.0
2012-02-02 13:00:00	IWM	ETF	81.09	81.26	80.995	81.21	3425247.0
2012-02-02 14:00:00	IWM	ETF	81.21	81.24	80.99	81.0895	3043753.0
2012-02-02 15:00:00	IWM	ETF	81.09	81.22	81.06	81.16	6393495.0
2012-02-02 16:00:00	IWM	ETF	81.16	81.28	80.8305	81.11	3026262.0
2012-02-02 17:00:00	IWM	ETF	81.13	81.16	81.12	81.16	50300.0
2012-02-02 18:00:00	IWM	ETF	81.14	81.19	81.14	81.18	6022.0
2012-02-02 19:00:00	IWM	ETF	81.18	81.18	81.18	81.18	1000.0
2012-02-02 07:00:00	DIA	ETF	126.81	126.81	126.6	126.6	3300.0
2012-02-02 08:00:00	DIA	ETF	126.69	126.92	126.64	126.83	4750.0
2012-02-02 09:00:00	DIA	ETF	126.87	127.16	126.68	126.85	488740.0

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

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