PREVIEW / etf_1hour / 2010-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-30.parquet
  size:    161 KB
  rows:    4,896

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
2010-08-30 04:00:00	SPY	ETF	107.2	107.22	107.13	107.15	10000.0
2010-08-30 05:00:00	SPY	ETF	107.15	107.15	107.11	107.13	2675.0
2010-08-30 06:00:00	SPY	ETF	107.07	107.1	106.89	106.89	20675.0
2010-08-30 07:00:00	SPY	ETF	106.87	106.98	106.75	106.83	248395.0
2010-08-30 08:00:00	SPY	ETF	107.1	107.1	106.54	106.65	4902387.0
2010-08-30 09:00:00	SPY	ETF	106.65	106.91	106.49	106.86	18659781.0
2010-08-30 10:00:00	SPY	ETF	106.85	106.9	106.3	106.61	27510385.0
2010-08-30 11:00:00	SPY	ETF	106.62	106.65	106.04	106.17	17665910.0
2010-08-30 12:00:00	SPY	ETF	106.175	106.46	106.1	106.28	9808598.0
2010-08-30 13:00:00	SPY	ETF	106.27	106.39	105.94	106.01	15010522.0
2010-08-30 14:00:00	SPY	ETF	106.0	106.17	105.78	105.9901	14426171.0
2010-08-30 15:00:00	SPY	ETF	105.99	106.05	105.3	105.33	39568684.0
2010-08-30 16:00:00	SPY	ETF	105.32	106.9008	105.02	105.15	10534318.0
2010-08-30 17:00:00	SPY	ETF	105.15	106.9008	105.02	105.06	2129572.0
2010-08-30 18:00:00	SPY	ETF	105.07	105.16	105.07	105.14	150953.0
2010-08-30 19:00:00	SPY	ETF	105.14	105.34	105.14	105.25	219923.0
2010-08-30 05:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	100.0
2010-08-30 06:00:00	QQQ	ETF	44.1	44.1	44.05	44.05	500.0
2010-08-30 07:00:00	QQQ	ETF	44.01	44.1	43.96	44.0	506992.0
2010-08-30 08:00:00	QQQ	ETF	44.0	44.04	43.84	43.91	4787521.0
2010-08-30 09:00:00	QQQ	ETF	43.91	44.24	43.86	44.23	11466023.0
2010-08-30 10:00:00	QQQ	ETF	44.22	44.25	43.96	44.11	9336163.0
2010-08-30 11:00:00	QQQ	ETF	44.11	44.13	43.85	43.89	4532243.0
2010-08-30 12:00:00	QQQ	ETF	43.9	44.0265	43.8659	43.97	2562543.0
2010-08-30 13:00:00	QQQ	ETF	43.97	44.0127	43.82	43.84	3433333.0
2010-08-30 14:00:00	QQQ	ETF	43.84	43.96	43.77	43.8939	3360401.0
2010-08-30 15:00:00	QQQ	ETF	43.89	43.92	43.6	43.61	7865794.0
2010-08-30 16:00:00	QQQ	ETF	43.61	43.9433	43.52	43.58	1370185.0
2010-08-30 17:00:00	QQQ	ETF	43.57	43.57	43.52	43.55	40940.0
2010-08-30 18:00:00	QQQ	ETF	43.56	43.58	43.55	43.56	8100.0
2010-08-30 19:00:00	QQQ	ETF	43.57	43.63	43.57	43.61	85017.0
2010-08-30 06:00:00	IWM	ETF	61.91	61.91	61.7	61.7	4500.0
2010-08-30 07:00:00	IWM	ETF	61.61	61.77	61.61	61.65	109200.0
2010-08-30 08:00:00	IWM	ETF	61.82	61.82	61.46	61.5	1774433.0
2010-08-30 09:00:00	IWM	ETF	61.52	61.66	61.31	61.59	6886304.0
2010-08-30 10:00:00	IWM	ETF	61.58	61.64	61.1	61.36	7417875.0
2010-08-30 11:00:00	IWM	ETF	61.36	61.4	60.91	60.99	4156177.0
2010-08-30 12:00:00	IWM	ETF	60.99	61.32	60.93	61.11	3056388.0
2010-08-30 13:00:00	IWM	ETF	61.11	61.228	60.75	60.85	2817156.0
2010-08-30 14:00:00	IWM	ETF	60.84	60.95	60.64	60.74	3646008.0
2010-08-30 15:00:00	IWM	ETF	60.74	60.8	60.27	60.28	8891038.0
2010-08-30 16:00:00	IWM	ETF	60.28	61.7423	60.18	60.23	1619442.0
2010-08-30 17:00:00	IWM	ETF	60.25	60.25	60.17	60.18	4080.0
2010-08-30 18:00:00	IWM	ETF	60.18	60.19	60.17	60.17	3100.0
2010-08-30 19:00:00	IWM	ETF	60.24	60.27	60.16	60.25	5600.0
2010-08-30 06:00:00	DIA	ETF	101.6	101.6	101.6	101.6	100.0
2010-08-30 07:00:00	DIA	ETF	101.49	101.54	101.44	101.44	920.0
2010-08-30 08:00:00	DIA	ETF	101.42	101.56	101.19	101.24	52992.0
2010-08-30 09:00:00	DIA	ETF	101.28	101.54	101.19	101.52	705346.0
2010-08-30 10:00:00	DIA	ETF	101.5381	101.54	101.02	101.32	819622.0

> showing 50 of 4,896 rows — these rows as CSV

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