PREVIEW / etf_1hour / 2005-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-27.parquet
  size:    30 KB
  rows:    917

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
2005-06-27 07:00:00	SPY	ETF	118.93	118.95	118.87	118.93	107000.0
2005-06-27 08:00:00	SPY	ETF	118.94	118.97	118.91	118.93	65700.0
2005-06-27 09:00:00	SPY	ETF	118.93	119.24	118.87	119.12	6837700.0
2005-06-27 10:00:00	SPY	ETF	119.12	119.38	118.97	119.19	7861700.0
2005-06-27 11:00:00	SPY	ETF	119.19	119.28	119.01	119.21	6673900.0
2005-06-27 12:00:00	SPY	ETF	119.22	119.41	119.06	119.1	5572100.0
2005-06-27 13:00:00	SPY	ETF	119.09	119.32	118.77	118.78	5219600.0
2005-06-27 14:00:00	SPY	ETF	118.78	119.05	118.75	118.98	6270200.0
2005-06-27 15:00:00	SPY	ETF	118.98	119.23	118.92	119.04	8932800.0
2005-06-27 16:00:00	SPY	ETF	119.05	119.21	118.92	119.12	2738700.0
2005-06-27 17:00:00	SPY	ETF	119.11	119.13	119.09	119.12	15300.0
2005-06-27 18:00:00	SPY	ETF	119.12	119.12	119.1	119.12	2300.0
2005-06-27 19:00:00	SPY	ETF	119.15	119.15	119.15	119.15	500.0
2005-06-27 09:00:00	QQQ	ETF	36.94	37.06	36.89	36.97	10772800.0
2005-06-27 10:00:00	QQQ	ETF	36.98	37.05	36.87	36.95	9738700.0
2005-06-27 11:00:00	QQQ	ETF	36.95	36.98	36.88	36.95	8782500.0
2005-06-27 12:00:00	QQQ	ETF	36.96	37.03	36.84	36.87	7147100.0
2005-06-27 13:00:00	QQQ	ETF	36.87	36.9	36.73	36.73	9571800.0
2005-06-27 14:00:00	QQQ	ETF	36.74	36.78	36.7	36.75	7857300.0
2005-06-27 15:00:00	QQQ	ETF	36.76	36.87	36.72	36.78	12310500.0
2005-06-27 07:00:00	IWM	ETF	62.14	62.14	62.14	62.14	100.0
2005-06-27 08:00:00	IWM	ETF	62.2	62.2	62.19	62.19	1000.0
2005-06-27 09:00:00	IWM	ETF	62.2	62.47	62.2	62.25	2796300.0
2005-06-27 10:00:00	IWM	ETF	62.254	62.44	62.1	62.29	2933000.0
2005-06-27 11:00:00	IWM	ETF	62.29	62.49	62.22	62.43	6195800.0
2005-06-27 12:00:00	IWM	ETF	62.43	62.59	62.36	62.39	1192700.0
2005-06-27 13:00:00	IWM	ETF	62.39	62.5	62.17	62.18	1294000.0
2005-06-27 14:00:00	IWM	ETF	62.18	62.37	62.13	62.31	2230800.0
2005-06-27 15:00:00	IWM	ETF	62.31	62.47	62.15	62.41	2803500.0
2005-06-27 16:00:00	IWM	ETF	62.42	62.55	62.35	62.55	1130300.0
2005-06-27 18:00:00	IWM	ETF	62.5	62.5	62.49	62.49	1000.0
2005-06-27 08:00:00	DIA	ETF	102.82	102.82	102.8	102.8	600.0
2005-06-27 09:00:00	DIA	ETF	102.8	103.17	102.79	103.04	1194500.0
2005-06-27 10:00:00	DIA	ETF	103.04	103.26	102.91	103.07	767000.0
2005-06-27 11:00:00	DIA	ETF	103.07	103.1	102.86	103.05	897700.0
2005-06-27 12:00:00	DIA	ETF	103.06	103.17	102.88	102.91	393100.0
2005-06-27 13:00:00	DIA	ETF	102.9	103.0	102.47	102.47	2697700.0
2005-06-27 14:00:00	DIA	ETF	102.48	102.77	102.44	102.68	1632000.0
2005-06-27 15:00:00	DIA	ETF	102.67	103.02	102.63	102.87	1057700.0
2005-06-27 16:00:00	DIA	ETF	102.87	102.92	102.84	102.92	179100.0
2005-06-27 18:00:00	DIA	ETF	102.9	102.9	102.8	102.8	4700.0
2005-06-27 08:00:00	GLD	ETF	43.8	43.86	43.8	43.86	700.0
2005-06-27 09:00:00	GLD	ETF	43.89	43.91	43.85	43.88	79800.0
2005-06-27 10:00:00	GLD	ETF	43.85	43.87	43.76	43.76	111300.0
2005-06-27 11:00:00	GLD	ETF	43.76	43.84	43.74	43.77	247400.0
2005-06-27 12:00:00	GLD	ETF	43.76	43.85	43.73	43.84	124700.0
2005-06-27 13:00:00	GLD	ETF	43.83	43.93	43.83	43.92	113300.0
2005-06-27 14:00:00	GLD	ETF	43.92	43.92	43.85	43.89	72100.0
2005-06-27 15:00:00	GLD	ETF	43.89	43.91	43.87	43.89	219400.0
2005-06-27 19:00:00	GLD	ETF	43.86	43.86	43.86	43.86	100.0

> showing 50 of 917 rows — these rows as CSV

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