PREVIEW / etf_1hour / 2006-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-27.parquet
  size:    55 KB
  rows:    1,750

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
2006-10-27 06:00:00	SPY	ETF	138.61	138.61	138.59	138.59	25000.0
2006-10-27 07:00:00	SPY	ETF	138.57	138.63	138.53	138.59	105200.0
2006-10-27 08:00:00	SPY	ETF	138.65	138.65	138.42	138.58	3093800.0
2006-10-27 09:00:00	SPY	ETF	138.58	138.63	138.2	138.36	10399100.0
2006-10-27 10:00:00	SPY	ETF	138.36	138.56	138.26	138.47	9900600.0
2006-10-27 11:00:00	SPY	ETF	138.46	138.68	138.4	138.57	5858600.0
2006-10-27 12:00:00	SPY	ETF	138.56	138.75	138.49	138.57	3497900.0
2006-10-27 13:00:00	SPY	ETF	138.58	138.68	138.04	138.21	9310100.0
2006-10-27 14:00:00	SPY	ETF	138.21	138.31	137.67	137.91	13396800.0
2006-10-27 15:00:00	SPY	ETF	137.91	138.01	137.63	137.93	10911300.0
2006-10-27 16:00:00	SPY	ETF	137.94	138.9692	137.77	137.9	4654900.0
2006-10-27 17:00:00	SPY	ETF	137.84	137.87	136.7802	137.87	2053300.0
2006-10-27 18:00:00	SPY	ETF	137.87	137.87	137.81	137.82	2100.0
2006-10-27 19:00:00	SPY	ETF	137.82	137.82	137.81	137.81	1400.0
2006-10-27 09:00:00	QQQ	ETF	42.73	42.78	42.59	42.69	13753300.0
2006-10-27 10:00:00	QQQ	ETF	42.7	42.78	42.63	42.71	12950900.0
2006-10-27 11:00:00	QQQ	ETF	42.71	42.79	42.65	42.76	10350300.0
2006-10-27 12:00:00	QQQ	ETF	42.77	42.82	42.71	42.73	7780600.0
2006-10-27 13:00:00	QQQ	ETF	42.74	42.76	42.28	42.38	21332100.0
2006-10-27 14:00:00	QQQ	ETF	42.38	42.44	42.08	42.22	27886400.0
2006-10-27 15:00:00	QQQ	ETF	42.22	42.3	42.13	42.22	26564500.0
2006-10-27 07:00:00	IWM	ETF	76.9	76.9	76.9	76.9	100.0
2006-10-27 08:00:00	IWM	ETF	76.9	76.97	76.78	76.9	410900.0
2006-10-27 09:00:00	IWM	ETF	76.92	76.95	76.43	76.86	6860900.0
2006-10-27 10:00:00	IWM	ETF	76.86	77.11	76.79	76.93	9290400.0
2006-10-27 11:00:00	IWM	ETF	76.93	77.02	76.75	76.91	5663500.0
2006-10-27 12:00:00	IWM	ETF	76.91	77.03	76.81	76.84	2354700.0
2006-10-27 13:00:00	IWM	ETF	76.84	76.97	76.33	76.56	6281500.0
2006-10-27 14:00:00	IWM	ETF	76.56	76.57	76.11	76.31	7792700.0
2006-10-27 15:00:00	IWM	ETF	76.31	76.37	75.94	76.11	8792500.0
2006-10-27 16:00:00	IWM	ETF	76.12	77.08	76.0	76.35	3121500.0
2006-10-27 17:00:00	IWM	ETF	76.1	76.2	76.1	76.1	73000.0
2006-10-27 07:00:00	DIA	ETF	121.27	121.27	121.27	121.27	1000.0
2006-10-27 08:00:00	DIA	ETF	121.27	121.31	121.14	121.22	79300.0
2006-10-27 09:00:00	DIA	ETF	121.19	121.26	120.9	121.07	949800.0
2006-10-27 10:00:00	DIA	ETF	121.06	121.27	120.95	121.25	1381100.0
2006-10-27 11:00:00	DIA	ETF	121.25	121.41	121.21	121.31	1105000.0
2006-10-27 12:00:00	DIA	ETF	121.3	121.4	121.23	121.31	454300.0
2006-10-27 13:00:00	DIA	ETF	121.3	121.4	120.98	121.1	1171600.0
2006-10-27 14:00:00	DIA	ETF	121.1	121.17	120.64	120.8	1964700.0
2006-10-27 15:00:00	DIA	ETF	120.8	120.9	120.63	120.78	1424700.0
2006-10-27 16:00:00	DIA	ETF	120.84	120.9	120.78	120.89	43000.0
2006-10-27 17:00:00	DIA	ETF	120.86	120.9	120.86	120.86	58300.0
2006-10-27 18:00:00	DIA	ETF	120.89	120.89	120.89	120.89	100.0
2006-10-27 19:00:00	DIA	ETF	120.86	120.86	120.86	120.86	100.0
2006-10-27 08:00:00	GLD	ETF	59.05	59.24	58.95	59.16	217900.0
2006-10-27 09:00:00	GLD	ETF	59.13	59.6	59.12	59.32	633800.0
2006-10-27 10:00:00	GLD	ETF	59.3174	59.39	59.04	59.34	612900.0
2006-10-27 11:00:00	GLD	ETF	59.33	59.43	59.08	59.26	325800.0
2006-10-27 12:00:00	GLD	ETF	59.2599	59.39	59.21	59.3	307300.0

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

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