PREVIEW / etf_1hour / 2007-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-07.parquet
  size:    92 KB
  rows:    3,115

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-07 05:00:00	SPY	ETF	150.63	150.63	150.55	150.55	10500.0
2007-12-07 06:00:00	SPY	ETF	150.75	150.94	150.75	150.8	23200.0
2007-12-07 07:00:00	SPY	ETF	150.91	151.03	150.69	150.88	330000.0
2007-12-07 08:00:00	SPY	ETF	150.88	151.68	150.33	151.41	22356200.0
2007-12-07 09:00:00	SPY	ETF	151.41	151.63	151.0	151.17	25143639.0
2007-12-07 10:00:00	SPY	ETF	151.17	151.36	150.75	150.93	22364991.0
2007-12-07 11:00:00	SPY	ETF	150.9399	151.42	150.84	151.29	16475805.0
2007-12-07 12:00:00	SPY	ETF	151.29	151.36	151.11	151.12	8063534.0
2007-12-07 13:00:00	SPY	ETF	151.12	151.15	150.68	150.98	11822427.0
2007-12-07 14:00:00	SPY	ETF	150.99	151.28	150.84	151.0	8420225.0
2007-12-07 15:00:00	SPY	ETF	151.01	151.34	150.62	150.74	20341434.0
2007-12-07 16:00:00	SPY	ETF	150.7	151.62	150.59	150.86	9825400.0
2007-12-07 17:00:00	SPY	ETF	150.88	150.93	150.63	150.8	12500.0
2007-12-07 18:00:00	SPY	ETF	150.79	150.85	150.7	150.7	19200.0
2007-12-07 19:00:00	SPY	ETF	150.77	150.8	150.77	150.8	1800.0
2007-12-07 06:00:00	QQQ	ETF	52.2	52.21	52.2	52.21	3200.0
2007-12-07 07:00:00	QQQ	ETF	52.2	52.24	52.14	52.14	87518.0
2007-12-07 08:00:00	QQQ	ETF	52.32	52.49	52.02	52.34	5186897.0
2007-12-07 09:00:00	QQQ	ETF	52.36	52.4	52.08	52.1774	13493564.0
2007-12-07 10:00:00	QQQ	ETF	52.17	52.28	52.1099	52.22	15842554.0
2007-12-07 11:00:00	QQQ	ETF	52.23	52.45	52.18	52.35	15191182.0
2007-12-07 12:00:00	QQQ	ETF	52.3501	52.41	52.25	52.25	4531507.0
2007-12-07 13:00:00	QQQ	ETF	52.2526	52.3	52.16	52.27	9743603.0
2007-12-07 14:00:00	QQQ	ETF	52.28	52.46	52.27	52.38	6459768.0
2007-12-07 15:00:00	QQQ	ETF	52.38	52.54	52.32	52.37	14962303.0
2007-12-07 16:00:00	QQQ	ETF	52.36	52.44	52.32	52.37	3347614.0
2007-12-07 17:00:00	QQQ	ETF	52.38	52.4	52.35	52.36	105106.0
2007-12-07 18:00:00	QQQ	ETF	52.36	52.36	52.23	52.35	30997.0
2007-12-07 19:00:00	QQQ	ETF	52.33	52.33	52.25	52.3	7050.0
2007-12-07 07:00:00	IWM	ETF	78.41	78.41	78.29	78.31	7300.0
2007-12-07 08:00:00	IWM	ETF	78.25	78.75	78.25	78.71	14435500.0
2007-12-07 09:00:00	IWM	ETF	78.72	78.85	77.88	78.13	7361681.0
2007-12-07 10:00:00	IWM	ETF	78.13	78.36	77.99	78.19	8666766.0
2007-12-07 11:00:00	IWM	ETF	78.19	78.58	78.12	78.45	5821491.0
2007-12-07 12:00:00	IWM	ETF	78.46	78.56	78.3	78.3	2256500.0
2007-12-07 13:00:00	IWM	ETF	78.3	78.35	77.93	78.14	4946900.0
2007-12-07 14:00:00	IWM	ETF	78.13	78.44	78.11	78.34	4241866.0
2007-12-07 15:00:00	IWM	ETF	78.34	78.51	77.93	78.29	8282950.0
2007-12-07 16:00:00	IWM	ETF	78.29	78.47	78.11	78.36	3304285.0
2007-12-07 17:00:00	IWM	ETF	78.4	78.4	78.4	78.4	400.0
2007-12-07 07:00:00	DIA	ETF	136.1	136.1	135.99	135.99	500.0
2007-12-07 08:00:00	DIA	ETF	136.11	136.73	136.11	136.47	308700.0
2007-12-07 09:00:00	DIA	ETF	136.48	136.64	136.13	136.25	1520353.0
2007-12-07 10:00:00	DIA	ETF	136.25	136.42	136.09	136.24	1930214.0
2007-12-07 11:00:00	DIA	ETF	136.24	136.62	136.19	136.46	1247315.0
2007-12-07 12:00:00	DIA	ETF	136.51	136.57	136.34	136.34	443900.0
2007-12-07 13:00:00	DIA	ETF	136.36	136.41	136.1	136.36	884800.0
2007-12-07 14:00:00	DIA	ETF	136.36	136.68	136.32	136.47	739083.0
2007-12-07 15:00:00	DIA	ETF	136.49	136.77	136.11	136.31	1337978.0
2007-12-07 16:00:00	DIA	ETF	136.29	136.58	136.15	136.45	66200.0

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

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