PREVIEW / etf_1hour / 2007-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-10.parquet
  size:    61 KB
  rows:    1,908

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-10 04:00:00	SPY	ETF	140.64	140.64	140.64	140.64	1500.0
2007-01-10 06:00:00	SPY	ETF	140.62	140.62	140.62	140.62	1000.0
2007-01-10 07:00:00	SPY	ETF	140.63	140.65	140.5	140.62	360700.0
2007-01-10 08:00:00	SPY	ETF	140.5	140.64	140.42	140.62	1688500.0
2007-01-10 09:00:00	SPY	ETF	140.62	140.72	140.3	140.6	9946900.0
2007-01-10 10:00:00	SPY	ETF	140.6	141.06	140.56	140.94	13238400.0
2007-01-10 11:00:00	SPY	ETF	140.93	140.94	140.6	140.85	5253500.0
2007-01-10 12:00:00	SPY	ETF	140.86	140.99	140.59	140.89	6366500.0
2007-01-10 13:00:00	SPY	ETF	140.91	141.35	140.85	141.19	11988400.0
2007-01-10 14:00:00	SPY	ETF	141.2	141.42	141.11	141.29	7656300.0
2007-01-10 15:00:00	SPY	ETF	141.28	141.53	141.1081	141.4	9283700.0
2007-01-10 16:00:00	SPY	ETF	141.39	141.7	141.39	141.68	1503300.0
2007-01-10 17:00:00	SPY	ETF	141.67	141.7	141.61	141.67	105400.0
2007-01-10 18:00:00	SPY	ETF	141.65	141.66	141.57	141.57	41700.0
2007-01-10 19:00:00	SPY	ETF	141.6	141.63	141.57	141.61	14500.0
2007-01-10 04:00:00	QQQ	ETF	43.93	43.93	43.93	43.93	100.0
2007-01-10 06:00:00	QQQ	ETF	43.81	43.84	43.79	43.82	325000.0
2007-01-10 07:00:00	QQQ	ETF	43.86	43.89	43.8	43.89	238830.0
2007-01-10 08:00:00	QQQ	ETF	43.89	43.96	43.8	43.95	1029757.0
2007-01-10 09:00:00	QQQ	ETF	43.95	44.1	43.82	44.07	18075224.0
2007-01-10 10:00:00	QQQ	ETF	44.08	44.36	44.01	44.34	29448800.0
2007-01-10 11:00:00	QQQ	ETF	44.33	44.34	44.16	44.3	9680300.0
2007-01-10 12:00:00	QQQ	ETF	44.3	44.33	44.2	44.33	5476600.0
2007-01-10 13:00:00	QQQ	ETF	44.32	44.5	44.3	44.41	11321800.0
2007-01-10 14:00:00	QQQ	ETF	44.41	44.59	44.32	44.5	10673700.0
2007-01-10 15:00:00	QQQ	ETF	44.5	44.66	44.49	44.64	12706000.0
2007-01-10 16:00:00	QQQ	ETF	44.64	44.81	44.615	44.81	5228317.0
2007-01-10 17:00:00	QQQ	ETF	44.8	44.81	44.73	44.74	433394.0
2007-01-10 18:00:00	QQQ	ETF	44.74	44.75	44.73	44.74	97431.0
2007-01-10 19:00:00	QQQ	ETF	44.73	44.77	44.73	44.74	36225.0
2007-01-10 07:00:00	IWM	ETF	76.75	76.75	76.75	76.75	1000.0
2007-01-10 08:00:00	IWM	ETF	77.67	77.67	76.48	76.77	381500.0
2007-01-10 09:00:00	IWM	ETF	76.75	76.96	76.57	76.85	5324000.0
2007-01-10 10:00:00	IWM	ETF	76.84	77.23	76.73	77.1	11159200.0
2007-01-10 11:00:00	IWM	ETF	77.11	77.12	76.82	76.9	4079800.0
2007-01-10 12:00:00	IWM	ETF	76.9	76.91	76.69	76.85	6215100.0
2007-01-10 13:00:00	IWM	ETF	76.85	77.02	76.81	76.87	6223600.0
2007-01-10 14:00:00	IWM	ETF	76.86	77.14	76.85	77.02	4379500.0
2007-01-10 15:00:00	IWM	ETF	77.02	77.38	77.02	77.23	4809100.0
2007-01-10 16:00:00	IWM	ETF	77.25	77.53	76.83	76.83	1830800.0
2007-01-10 17:00:00	IWM	ETF	77.45	77.46	77.44	77.45	60000.0
2007-01-10 18:00:00	IWM	ETF	77.45	77.5	77.44	77.47	18900.0
2007-01-10 19:00:00	IWM	ETF	77.47	77.47	77.47	77.47	1000.0
2007-01-10 08:00:00	DIA	ETF	123.76	123.81	123.62	123.77	22100.0
2007-01-10 09:00:00	DIA	ETF	123.78	123.85	123.5	123.67	1359900.0
2007-01-10 10:00:00	DIA	ETF	123.67	124.02	123.6	123.92	1433500.0
2007-01-10 11:00:00	DIA	ETF	123.92	123.94	123.66	123.89	526500.0
2007-01-10 12:00:00	DIA	ETF	123.88	123.98	123.66	123.91	1863900.0
2007-01-10 13:00:00	DIA	ETF	123.92	124.32	123.88	124.2	1043800.0
2007-01-10 14:00:00	DIA	ETF	124.19	124.37	124.12	124.25	1110700.0

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

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