PREVIEW / etf_1hour / 2010-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-30.parquet
  size:    165 KB
  rows:    5,128

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-30 04:00:00	SPY	ETF	126.01	126.01	125.98	125.98	900.0
2010-12-30 05:00:00	SPY	ETF	126.0	126.0	125.98	125.98	600.0
2010-12-30 06:00:00	SPY	ETF	125.9	125.9	125.77	125.79	6200.0
2010-12-30 07:00:00	SPY	ETF	125.85	125.86	125.72	125.8	109308.0
2010-12-30 08:00:00	SPY	ETF	125.79	125.89	125.73	125.83	788254.0
2010-12-30 09:00:00	SPY	ETF	125.84	126.13	125.75	125.87	9547263.0
2010-12-30 10:00:00	SPY	ETF	125.87	125.93	125.6	125.76	12324830.0
2010-12-30 11:00:00	SPY	ETF	125.77	125.82	125.53	125.59	7480823.0
2010-12-30 12:00:00	SPY	ETF	125.585	125.69	125.58	125.65	4153011.0
2010-12-30 13:00:00	SPY	ETF	125.66	125.73	125.6	125.72	4155118.0
2010-12-30 14:00:00	SPY	ETF	125.7225	125.83	125.69	125.785	8731382.0
2010-12-30 15:00:00	SPY	ETF	125.78	125.95	125.71	125.76	16978847.0
2010-12-30 16:00:00	SPY	ETF	125.76	125.93	125.705	125.81	10013396.0
2010-12-30 17:00:00	SPY	ETF	125.83	125.86	125.8	125.8	31482.0
2010-12-30 18:00:00	SPY	ETF	125.83	125.83	125.81	125.82	4050.0
2010-12-30 19:00:00	SPY	ETF	125.83	125.89	125.8	125.89	20283.0
2010-12-30 04:00:00	QQQ	ETF	54.8	54.8	54.72	54.72	400.0
2010-12-30 05:00:00	QQQ	ETF	54.76	54.76	54.76	54.76	100.0
2010-12-30 06:00:00	QQQ	ETF	54.72	54.72	54.72	54.72	100.0
2010-12-30 07:00:00	QQQ	ETF	54.74	54.74	54.69	54.72	2780.0
2010-12-30 08:00:00	QQQ	ETF	54.7	54.8	54.67	54.75	136673.0
2010-12-30 09:00:00	QQQ	ETF	54.76	54.8	54.67	54.7	4171315.0
2010-12-30 10:00:00	QQQ	ETF	54.7	54.71	54.57	54.63	5131614.0
2010-12-30 11:00:00	QQQ	ETF	54.63	54.65	54.55	54.58	3127497.0
2010-12-30 12:00:00	QQQ	ETF	54.581	54.65	54.56	54.61	2619925.0
2010-12-30 13:00:00	QQQ	ETF	54.615	54.65	54.59	54.648	2158013.0
2010-12-30 14:00:00	QQQ	ETF	54.65	54.69	54.63	54.679	1743187.0
2010-12-30 15:00:00	QQQ	ETF	54.67	54.75	54.64	54.6499	4819088.0
2010-12-30 16:00:00	QQQ	ETF	54.64	54.715	54.56	54.63	1004840.0
2010-12-30 17:00:00	QQQ	ETF	54.62	54.64	54.61	54.64	13378.0
2010-12-30 18:00:00	QQQ	ETF	54.62	54.62	54.62	54.62	900.0
2010-12-30 19:00:00	QQQ	ETF	54.63	54.67	54.63	54.67	8945.0
2010-12-30 04:00:00	IWM	ETF	78.75	78.75	78.75	78.75	288.0
2010-12-30 06:00:00	IWM	ETF	78.74	78.75	78.72	78.74	3000.0
2010-12-30 07:00:00	IWM	ETF	78.73	78.76	78.7	78.76	18600.0
2010-12-30 08:00:00	IWM	ETF	78.76	78.89	78.7	78.84	213623.0
2010-12-30 09:00:00	IWM	ETF	78.84	79.22	78.79	79.0	5267969.0
2010-12-30 10:00:00	IWM	ETF	79.0	79.13	78.83	79.095	3379011.0
2010-12-30 11:00:00	IWM	ETF	79.09	79.13	78.96	78.9799	2515415.0
2010-12-30 12:00:00	IWM	ETF	78.98	79.12	78.8799	79.05	2621812.0
2010-12-30 13:00:00	IWM	ETF	79.05	79.1	79.03	79.0985	1485794.0
2010-12-30 14:00:00	IWM	ETF	79.09	79.17	79.0	79.04	3306239.0
2010-12-30 15:00:00	IWM	ETF	79.04	79.1	78.79	78.81	5815712.0
2010-12-30 16:00:00	IWM	ETF	78.8	78.8	78.72	78.76	1484536.0
2010-12-30 17:00:00	IWM	ETF	78.76	78.78	78.74	78.77	19100.0
2010-12-30 18:00:00	IWM	ETF	78.76	78.76	78.76	78.76	100.0
2010-12-30 19:00:00	IWM	ETF	78.76	78.81	78.76	78.81	600.0
2010-12-30 07:00:00	DIA	ETF	115.6	115.6	115.55	115.55	1000.0
2010-12-30 08:00:00	DIA	ETF	115.55	115.65	115.55	115.63	11100.0
2010-12-30 09:00:00	DIA	ETF	115.62	115.71	115.45	115.53	763104.0

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

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