PREVIEW / etf_1hour / 2007-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-03.parquet
  size:    64 KB
  rows:    1,954

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-01-03 04:00:00	SPY	ETF	142.71	142.71	142.71	142.71	1500.0
2007-01-03 06:00:00	SPY	ETF	142.51	142.52	142.37	142.42	14400.0
2007-01-03 07:00:00	SPY	ETF	142.42	142.59	142.4	142.53	433200.0
2007-01-03 08:00:00	SPY	ETF	142.5	143.17	141.62	142.43	2468600.0
2007-01-03 09:00:00	SPY	ETF	142.43	142.78	141.69	142.06	11822900.0
2007-01-03 10:00:00	SPY	ETF	142.05	142.86	141.99	142.58	15638000.0
2007-01-03 11:00:00	SPY	ETF	142.58	142.73	142.53	142.59	4608800.0
2007-01-03 12:00:00	SPY	ETF	142.58	142.62	142.38	142.56	5252100.0
2007-01-03 13:00:00	SPY	ETF	142.56	142.6	142.0	142.07	8498100.0
2007-01-03 14:00:00	SPY	ETF	142.06	142.23	140.57	140.7	21309900.0
2007-01-03 15:00:00	SPY	ETF	140.701	141.59	140.65	141.45	12974400.0
2007-01-03 16:00:00	SPY	ETF	141.46	141.53	141.34	141.42	984900.0
2007-01-03 17:00:00	SPY	ETF	141.44	141.46	141.43	141.43	4400.0
2007-01-03 18:00:00	SPY	ETF	141.46	141.5	141.43	141.5	1300.0
2007-01-03 19:00:00	SPY	ETF	141.47	141.47	141.37	141.38	37900.0
2007-01-03 04:00:00	QQQ	ETF	43.56	43.56	43.56	43.56	200.0
2007-01-03 05:00:00	QQQ	ETF	43.54	43.54	43.54	43.54	4500.0
2007-01-03 06:00:00	QQQ	ETF	43.56	43.56	43.51	43.51	12000.0
2007-01-03 07:00:00	QQQ	ETF	43.52	43.6	43.52	43.58	520550.0
2007-01-03 08:00:00	QQQ	ETF	43.58	43.59	43.16	43.52	2517187.0
2007-01-03 09:00:00	QQQ	ETF	43.52	45.6	43.43	43.54	18935174.0
2007-01-03 10:00:00	QQQ	ETF	43.5	44.06	43.49	43.95	35892200.0
2007-01-03 11:00:00	QQQ	ETF	43.94	43.98	43.88	43.9	6742500.0
2007-01-03 12:00:00	QQQ	ETF	43.9	43.92	43.78	43.84	7189300.0
2007-01-03 13:00:00	QQQ	ETF	43.85	43.88	43.58	43.61	11713100.0
2007-01-03 14:00:00	QQQ	ETF	43.61	43.67	42.52	42.68	50194500.0
2007-01-03 15:00:00	QQQ	ETF	42.69	43.23	42.64	43.23	23362500.0
2007-01-03 16:00:00	QQQ	ETF	43.23	43.33	43.23	43.3	2018923.0
2007-01-03 17:00:00	QQQ	ETF	43.3	43.3	43.28	43.28	64269.0
2007-01-03 18:00:00	QQQ	ETF	43.3	43.31	42.687	43.3	55084.0
2007-01-03 19:00:00	QQQ	ETF	43.32	43.32	42.687	43.3	67546.0
2007-01-03 08:00:00	IWM	ETF	78.34	78.89	78.03	78.75	1250900.0
2007-01-03 09:00:00	IWM	ETF	78.74	78.91	78.12	78.49	7220200.0
2007-01-03 10:00:00	IWM	ETF	78.49	79.12	78.43	78.83	10679300.0
2007-01-03 11:00:00	IWM	ETF	78.83	78.92	78.75	78.76	4257000.0
2007-01-03 12:00:00	IWM	ETF	78.76	78.88	78.62	78.72	3375500.0
2007-01-03 13:00:00	IWM	ETF	78.72	78.76	78.37	78.41	4281600.0
2007-01-03 14:00:00	IWM	ETF	78.4	78.46	77.22	77.33	12139300.0
2007-01-03 15:00:00	IWM	ETF	77.33	78.16	77.27	78.14	9964600.0
2007-01-03 16:00:00	IWM	ETF	78.14	78.26	78.14	78.14	201800.0
2007-01-03 18:00:00	IWM	ETF	78.17	78.17	78.17	78.17	2000.0
2007-01-03 07:00:00	DIA	ETF	125.17	125.31	125.17	125.2	60500.0
2007-01-03 08:00:00	DIA	ETF	125.21	125.35	124.41	125.24	104800.0
2007-01-03 09:00:00	DIA	ETF	125.24	125.36	124.99	125.0	1835500.0
2007-01-03 10:00:00	DIA	ETF	124.96	125.68	124.94	125.52	2206200.0
2007-01-03 11:00:00	DIA	ETF	125.51	125.65	125.49	125.55	600500.0
2007-01-03 12:00:00	DIA	ETF	125.54	125.58	125.4	125.54	539400.0
2007-01-03 13:00:00	DIA	ETF	125.5401	125.58	125.09	125.17	982300.0
2007-01-03 14:00:00	DIA	ETF	125.16	125.29	123.88	124.02	3218000.0
2007-01-03 15:00:00	DIA	ETF	124.02	124.63	123.99	124.6	1876200.0

> showing 50 of 1,954 rows — these rows as CSV

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