PREVIEW / etf_1hour / 2007-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-10.parquet
  size:    91 KB
  rows:    3,107

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
2007-12-10 04:00:00	SPY	ETF	150.5	150.97	150.5	150.97	3800.0
2007-12-10 05:00:00	SPY	ETF	151.09	151.26	151.09	151.14	11500.0
2007-12-10 06:00:00	SPY	ETF	151.18	151.32	151.18	151.2	22600.0
2007-12-10 07:00:00	SPY	ETF	151.24	151.5	151.08	151.48	481500.0
2007-12-10 08:00:00	SPY	ETF	151.49	151.56	151.15	151.31	1536450.0
2007-12-10 09:00:00	SPY	ETF	151.32	151.52	150.86	151.43	11730334.0
2007-12-10 10:00:00	SPY	ETF	151.42	152.17	151.42	152.16	24947838.0
2007-12-10 11:00:00	SPY	ETF	152.16	152.23	151.75	151.83	15854674.0
2007-12-10 12:00:00	SPY	ETF	151.82	152.01	151.7	151.83	6139062.0
2007-12-10 13:00:00	SPY	ETF	151.84	152.25	151.65	151.7	9467201.0
2007-12-10 14:00:00	SPY	ETF	151.7	151.97	151.48	151.65	13912682.0
2007-12-10 15:00:00	SPY	ETF	151.65	152.05	151.57	152.03	18617167.0
2007-12-10 16:00:00	SPY	ETF	152.05	152.22	151.8176	152.21	13895800.0
2007-12-10 17:00:00	SPY	ETF	152.23	152.33	152.08	152.27	4044800.0
2007-12-10 18:00:00	SPY	ETF	152.27	152.27	152.17	152.2	84600.0
2007-12-10 19:00:00	SPY	ETF	152.17	152.25	152.09	152.16	20700.0
2007-12-10 04:00:00	QQQ	ETF	52.31	52.43	52.31	52.43	3270.0
2007-12-10 06:00:00	QQQ	ETF	52.48	52.48	52.48	52.48	1000.0
2007-12-10 07:00:00	QQQ	ETF	52.44	52.58	52.4	52.58	249512.0
2007-12-10 08:00:00	QQQ	ETF	52.57	52.6	52.49	52.5	1262513.0
2007-12-10 09:00:00	QQQ	ETF	52.5	52.55	52.32	52.38	11903784.0
2007-12-10 10:00:00	QQQ	ETF	52.38	52.68	52.38	52.67	21073527.0
2007-12-10 11:00:00	QQQ	ETF	52.67	52.69	52.52	52.5724	7943156.0
2007-12-10 12:00:00	QQQ	ETF	52.57	52.62	52.52	52.5401	3544814.0
2007-12-10 13:00:00	QQQ	ETF	52.54	52.67	52.43	52.44	7085940.0
2007-12-10 14:00:00	QQQ	ETF	52.44	52.65	52.39	52.46	8001373.0
2007-12-10 15:00:00	QQQ	ETF	52.468	52.55	52.4305	52.55	10481538.0
2007-12-10 16:00:00	QQQ	ETF	52.55	52.74	52.49	52.74	3861482.0
2007-12-10 17:00:00	QQQ	ETF	52.74	52.75	52.72	52.73	152229.0
2007-12-10 18:00:00	QQQ	ETF	52.73	52.75	52.68	52.68	53374.0
2007-12-10 19:00:00	QQQ	ETF	52.67	52.69	52.65	52.69	40362.0
2007-12-10 07:00:00	IWM	ETF	78.37	78.56	77.67	78.56	8200.0
2007-12-10 08:00:00	IWM	ETF	78.63	78.68	78.45	78.57	614000.0
2007-12-10 09:00:00	IWM	ETF	78.53	78.71	78.2	78.62	5730350.0
2007-12-10 10:00:00	IWM	ETF	78.62	79.14	76.87	79.13	9128316.0
2007-12-10 11:00:00	IWM	ETF	79.13	79.17	78.76	78.82	6343300.0
2007-12-10 12:00:00	IWM	ETF	78.81	79.16	78.64	79.06	4493100.0
2007-12-10 13:00:00	IWM	ETF	79.06	79.25	78.68	78.69	4242600.0
2007-12-10 14:00:00	IWM	ETF	78.69	78.82	78.44	78.6	5085900.0
2007-12-10 15:00:00	IWM	ETF	78.59	79.0	78.52	78.99	8532400.0
2007-12-10 16:00:00	IWM	ETF	78.99	79.27	78.82	79.25	7262812.0
2007-12-10 17:00:00	IWM	ETF	79.25	79.26	79.17	79.17	96400.0
2007-12-10 18:00:00	IWM	ETF	79.2	79.2	79.2	79.2	3000.0
2007-12-10 19:00:00	IWM	ETF	79.21	79.21	79.2	79.2	500.0
2007-12-10 08:00:00	DIA	ETF	136.85	136.96	136.85	136.91	12700.0
2007-12-10 09:00:00	DIA	ETF	136.83	136.89	136.51	136.88	883637.0
2007-12-10 10:00:00	DIA	ETF	136.86	137.46	136.85	137.45	1790100.0
2007-12-10 11:00:00	DIA	ETF	137.45	137.49	137.15	137.26	1162800.0
2007-12-10 12:00:00	DIA	ETF	137.27	137.44	137.19	137.3	691200.0
2007-12-10 13:00:00	DIA	ETF	137.31	137.63	137.07	137.09	793600.0

> showing 50 of 3,107 rows — these rows as CSV

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