PREVIEW / etf_1hour / 2010-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-06.parquet
  size:    146 KB
  rows:    4,662

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-01-06 04:00:00	SPY	ETF	113.32	113.37	113.31	113.31	1018.0
2010-01-06 05:00:00	SPY	ETF	113.28	113.44	113.28	113.44	17618.0
2010-01-06 06:00:00	SPY	ETF	113.49	113.49	113.34	113.36	20400.0
2010-01-06 07:00:00	SPY	ETF	113.39	113.39	113.19	113.35	234683.0
2010-01-06 08:00:00	SPY	ETF	113.37	113.6	113.22	113.57	3284142.0
2010-01-06 09:00:00	SPY	ETF	113.56	113.7	113.43	113.57	13759380.0
2010-01-06 10:00:00	SPY	ETF	113.56	113.8	113.51	113.76	17358304.0
2010-01-06 11:00:00	SPY	ETF	113.76	113.88	113.6701	113.705	12762870.0
2010-01-06 12:00:00	SPY	ETF	113.71	113.75	113.52	113.69	10462419.0
2010-01-06 13:00:00	SPY	ETF	113.69	113.78	113.54	113.63	11550163.0
2010-01-06 14:00:00	SPY	ETF	113.63	113.99	113.63	113.9	14094131.0
2010-01-06 15:00:00	SPY	ETF	113.9	113.93	113.61	113.74	21197660.0
2010-01-06 16:00:00	SPY	ETF	113.73	113.94	113.51	113.71	7879569.0
2010-01-06 17:00:00	SPY	ETF	113.7	113.74	113.66	113.73	2111422.0
2010-01-06 18:00:00	SPY	ETF	113.71	113.75	113.65	113.7	27960.0
2010-01-06 19:00:00	SPY	ETF	113.67	113.81	113.67	113.79	29315.0
2010-01-06 04:00:00	QQQ	ETF	46.33	46.33	46.29	46.29	650.0
2010-01-06 05:00:00	QQQ	ETF	46.31	46.38	46.31	46.38	1500.0
2010-01-06 06:00:00	QQQ	ETF	46.37	46.39	46.33	46.33	27000.0
2010-01-06 07:00:00	QQQ	ETF	46.34	46.34	46.21	46.29	737424.0
2010-01-06 08:00:00	QQQ	ETF	46.3	46.41	46.21	46.4	2423608.0
2010-01-06 09:00:00	QQQ	ETF	46.4	46.55	46.34	46.4	14405027.0
2010-01-06 10:00:00	QQQ	ETF	46.4	46.52	46.35	46.45	10802853.0
2010-01-06 11:00:00	QQQ	ETF	46.45	46.5	46.28	46.28	7829835.0
2010-01-06 12:00:00	QQQ	ETF	46.28	46.3	46.14	46.24	9886081.0
2010-01-06 13:00:00	QQQ	ETF	46.24	46.29	46.07	46.115	6866796.0
2010-01-06 14:00:00	QQQ	ETF	46.11	46.4	46.09	46.3	13966289.0
2010-01-06 15:00:00	QQQ	ETF	46.3	46.31	46.09	46.18	13362218.0
2010-01-06 16:00:00	QQQ	ETF	46.19	46.4321	46.0934	46.21	10205046.0
2010-01-06 17:00:00	QQQ	ETF	46.21	46.432	46.18	46.18	407630.0
2010-01-06 18:00:00	QQQ	ETF	46.2	46.22	46.19	46.2	7866.0
2010-01-06 19:00:00	QQQ	ETF	46.21	46.27	46.21	46.24	37910.0
2010-01-06 07:00:00	IWM	ETF	63.52	63.61	63.52	63.61	10400.0
2010-01-06 08:00:00	IWM	ETF	63.61	63.82	63.37	63.81	222282.0
2010-01-06 09:00:00	IWM	ETF	63.8	64.1	63.71	63.85	5303440.0
2010-01-06 10:00:00	IWM	ETF	63.85	64.05	63.8	63.95	6829333.0
2010-01-06 11:00:00	IWM	ETF	63.95	64.08	63.88	63.89	5428965.0
2010-01-06 12:00:00	IWM	ETF	63.89	63.96	63.76	63.91	5112105.0
2010-01-06 13:00:00	IWM	ETF	63.92	63.95	63.6	63.68	8968922.0
2010-01-06 14:00:00	IWM	ETF	63.68	63.96	63.68	63.7725	9036657.0
2010-01-06 15:00:00	IWM	ETF	63.77	63.86	63.54	63.72	13385294.0
2010-01-06 16:00:00	IWM	ETF	63.72	63.95	63.65	63.78	1595088.0
2010-01-06 17:00:00	IWM	ETF	63.76	63.8143	63.74	63.79	1018900.0
2010-01-06 18:00:00	IWM	ETF	63.76	63.78	63.76	63.78	5100.0
2010-01-06 19:00:00	IWM	ETF	63.77	63.77	63.77	63.77	200.0
2010-01-06 08:00:00	DIA	ETF	105.4	105.56	105.37	105.55	19200.0
2010-01-06 09:00:00	DIA	ETF	105.55	105.67	105.36	105.55	1344749.0
2010-01-06 10:00:00	DIA	ETF	105.53	105.84	105.49	105.77	1346185.0
2010-01-06 11:00:00	DIA	ETF	105.78	105.85	105.65	105.66	780213.0
2010-01-06 12:00:00	DIA	ETF	105.66	105.7	105.46	105.57	461821.0

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

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