PREVIEW / etf_1hour / 2010-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-01.parquet
  size:    166 KB
  rows:    5,092

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-09-01 04:00:00	SPY	ETF	105.85	106.66	105.85	106.34	6200.0
2010-09-01 05:00:00	SPY	ETF	106.43	106.75	106.41	106.6	11318.0
2010-09-01 06:00:00	SPY	ETF	106.55	106.69	106.55	106.67	108705.0
2010-09-01 07:00:00	SPY	ETF	106.66	106.69	106.5	106.57	743470.0
2010-09-01 08:00:00	SPY	ETF	106.56	106.77	105.72	106.68	4931516.0
2010-09-01 09:00:00	SPY	ETF	106.69	107.25	105.31	107.14	33397302.0
2010-09-01 10:00:00	SPY	ETF	107.15	108.39	106.94	108.25	67180257.0
2010-09-01 11:00:00	SPY	ETF	108.25	108.48	108.17	108.34	23734320.0
2010-09-01 12:00:00	SPY	ETF	108.34	108.39	108.13	108.21	16599868.0
2010-09-01 13:00:00	SPY	ETF	108.22	108.45	108.18	108.36	15168724.0
2010-09-01 14:00:00	SPY	ETF	108.37	108.45	108.08	108.1701	25596429.0
2010-09-01 15:00:00	SPY	ETF	108.1783	108.61	108.06	108.47	50730905.0
2010-09-01 16:00:00	SPY	ETF	108.47	108.78	106.745	108.66	20481317.0
2010-09-01 17:00:00	SPY	ETF	108.65	108.73	108.58	108.59	4280706.0
2010-09-01 18:00:00	SPY	ETF	108.59	108.68	108.57	108.61	162846.0
2010-09-01 19:00:00	SPY	ETF	108.6	108.77	108.44	108.68	108843.0
2010-09-01 05:00:00	QQQ	ETF	43.95	44.15	43.93	44.09	28285.0
2010-09-01 06:00:00	QQQ	ETF	44.08	44.09	44.05	44.08	17599.0
2010-09-01 07:00:00	QQQ	ETF	44.09	44.1	44.02	44.08	155241.0
2010-09-01 08:00:00	QQQ	ETF	44.05	44.14	43.95	44.07	1253686.0
2010-09-01 09:00:00	QQQ	ETF	44.09	44.38	44.07	44.29	14356510.0
2010-09-01 10:00:00	QQQ	ETF	44.29	44.91	44.25	44.83	25011595.0
2010-09-01 11:00:00	QQQ	ETF	44.82	44.91	44.8	44.82	5979200.0
2010-09-01 12:00:00	QQQ	ETF	44.825	44.85	44.72	44.735	5502924.0
2010-09-01 13:00:00	QQQ	ETF	44.74	44.82	44.69	44.76	3695853.0
2010-09-01 14:00:00	QQQ	ETF	44.7601	44.8	44.61	44.66	6810265.0
2010-09-01 15:00:00	QQQ	ETF	44.66	44.82	44.6	44.75	12254540.0
2010-09-01 16:00:00	QQQ	ETF	44.75	44.87	44.6901	44.79	2628734.0
2010-09-01 17:00:00	QQQ	ETF	44.79	44.81	44.76	44.79	22879.0
2010-09-01 18:00:00	QQQ	ETF	44.79	44.81	44.77	44.8	12950.0
2010-09-01 19:00:00	QQQ	ETF	44.78	44.84	44.78	44.82	15906.0
2010-09-01 06:00:00	IWM	ETF	61.2	61.22	61.2	61.22	500.0
2010-09-01 07:00:00	IWM	ETF	61.26	61.29	61.17	61.23	28980.0
2010-09-01 08:00:00	IWM	ETF	61.22	61.36	61.03	61.19	286017.0
2010-09-01 09:00:00	IWM	ETF	61.2	61.49	60.18	61.28	6919866.0
2010-09-01 10:00:00	IWM	ETF	61.29	62.23	61.22	62.11	15217824.0
2010-09-01 11:00:00	IWM	ETF	62.1	62.19	62.0	62.09	4967668.0
2010-09-01 12:00:00	IWM	ETF	62.1	62.14	61.965	62.01	2584254.0
2010-09-01 13:00:00	IWM	ETF	62.01	62.3	61.97	62.2699	3576489.0
2010-09-01 14:00:00	IWM	ETF	62.27	62.33	62.03	62.199	5024498.0
2010-09-01 15:00:00	IWM	ETF	62.2	62.55	62.12	62.55	12989081.0
2010-09-01 16:00:00	IWM	ETF	62.54	62.63	60.2788	62.47	8474562.0
2010-09-01 17:00:00	IWM	ETF	62.47	62.5	60.2787	62.46	500740.0
2010-09-01 18:00:00	IWM	ETF	62.47	62.5	62.45	62.5	3100.0
2010-09-01 19:00:00	IWM	ETF	62.45	62.57	62.45	62.55	25102.0
2010-09-01 04:00:00	DIA	ETF	100.81	101.01	100.81	101.01	7000.0
2010-09-01 05:00:00	DIA	ETF	101.03	101.41	101.03	101.41	15000.0
2010-09-01 06:00:00	DIA	ETF	101.3	101.3	101.16	101.23	2100.0
2010-09-01 07:00:00	DIA	ETF	101.32	101.32	101.18	101.22	1850.0
2010-09-01 08:00:00	DIA	ETF	101.17	101.36	100.99	101.28	27927.0

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

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