PREVIEW / etf_1hour / 2010-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-28.parquet
  size:    167 KB
  rows:    5,139

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-12-28 04:00:00	SPY	ETF	125.9	125.9	125.84	125.87	8150.0
2010-12-28 06:00:00	SPY	ETF	125.98	125.98	125.98	125.98	2700.0
2010-12-28 07:00:00	SPY	ETF	125.95	126.01	125.86	125.86	91036.0
2010-12-28 08:00:00	SPY	ETF	125.86	125.96	125.81	125.88	568933.0
2010-12-28 09:00:00	SPY	ETF	125.87	125.95	125.6	125.72	7654228.0
2010-12-28 10:00:00	SPY	ETF	125.72	125.75	125.5	125.55	9022347.0
2010-12-28 11:00:00	SPY	ETF	125.55	125.65	125.54	125.57	5117167.0
2010-12-28 12:00:00	SPY	ETF	125.57	125.66	125.53	125.6599	6938950.0
2010-12-28 13:00:00	SPY	ETF	125.659	125.75	125.65	125.75	4636305.0
2010-12-28 14:00:00	SPY	ETF	125.7489	125.89	125.71	125.8666	5255980.0
2010-12-28 15:00:00	SPY	ETF	125.87	125.91	125.78	125.8	12343392.0
2010-12-28 16:00:00	SPY	ETF	125.8	125.84	125.615	125.71	3551713.0
2010-12-28 17:00:00	SPY	ETF	125.72	125.75	125.68	125.73	28269.0
2010-12-28 18:00:00	SPY	ETF	125.74	125.8	125.71	125.74	19059.0
2010-12-28 19:00:00	SPY	ETF	125.74	125.81	125.73	125.8	31894.0
2010-12-28 04:00:00	QQQ	ETF	54.82	54.82	54.78	54.78	300.0
2010-12-28 05:00:00	QQQ	ETF	54.8	54.8	54.8	54.8	200.0
2010-12-28 06:00:00	QQQ	ETF	54.85	54.87	54.85	54.87	700.0
2010-12-28 07:00:00	QQQ	ETF	54.85	54.88	54.81	54.82	186046.0
2010-12-28 08:00:00	QQQ	ETF	54.82	54.84	54.81	54.83	525657.0
2010-12-28 09:00:00	QQQ	ETF	54.82	54.92	54.66	54.71	5347016.0
2010-12-28 10:00:00	QQQ	ETF	54.71	54.76	54.61	54.63	4054305.0
2010-12-28 11:00:00	QQQ	ETF	54.63	54.68	54.61	54.62	1630485.0
2010-12-28 12:00:00	QQQ	ETF	54.615	54.64	54.55	54.63	1862483.0
2010-12-28 13:00:00	QQQ	ETF	54.639	54.66	54.62	54.65	1368021.0
2010-12-28 14:00:00	QQQ	ETF	54.651	54.7	54.625	54.695	1389810.0
2010-12-28 15:00:00	QQQ	ETF	54.7	54.745	54.66	54.68	3455623.0
2010-12-28 16:00:00	QQQ	ETF	54.68	54.73	54.625	54.66	834704.0
2010-12-28 17:00:00	QQQ	ETF	54.66	54.71	54.65	54.65	3852.0
2010-12-28 18:00:00	QQQ	ETF	54.64	54.64	54.64	54.64	4900.0
2010-12-28 19:00:00	QQQ	ETF	54.65	54.7	54.65	54.7	3202.0
2010-12-28 06:00:00	IWM	ETF	79.13	79.13	79.13	79.13	100.0
2010-12-28 07:00:00	IWM	ETF	79.15	79.19	79.09	79.09	56600.0
2010-12-28 08:00:00	IWM	ETF	79.1	79.13	79.05	79.09	237578.0
2010-12-28 09:00:00	IWM	ETF	79.08	79.16	78.73	78.78	5169537.0
2010-12-28 10:00:00	IWM	ETF	78.77	78.86	78.52	78.63	5225113.0
2010-12-28 11:00:00	IWM	ETF	78.63	78.75	78.622	78.65	1280407.0
2010-12-28 12:00:00	IWM	ETF	78.65	78.8	78.62	78.8	1384947.0
2010-12-28 13:00:00	IWM	ETF	78.8	78.9	78.78	78.87	1449014.0
2010-12-28 14:00:00	IWM	ETF	78.87	78.94	78.8	78.925	2359862.0
2010-12-28 15:00:00	IWM	ETF	78.925	78.94	78.7	78.73	4837386.0
2010-12-28 16:00:00	IWM	ETF	78.732	78.85	78.64	78.65	2484669.0
2010-12-28 17:00:00	IWM	ETF	78.69	78.69	78.65	78.65	500.0
2010-12-28 18:00:00	IWM	ETF	78.74	78.74	78.72	78.72	1100.0
2010-12-28 19:00:00	IWM	ETF	78.82	78.82	78.82	78.82	600.0
2010-12-28 07:00:00	DIA	ETF	115.84	115.84	115.73	115.73	1900.0
2010-12-28 08:00:00	DIA	ETF	115.74	115.78	115.72	115.78	1000.0
2010-12-28 09:00:00	DIA	ETF	115.78	115.82	115.4	115.4	1628487.0
2010-12-28 10:00:00	DIA	ETF	115.41	115.55	115.34	115.44	547004.0
2010-12-28 11:00:00	DIA	ETF	115.43	115.55	115.43	115.51	152836.0

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

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