PREVIEW / etf_1hour / 2009-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-22.parquet
  size:    125 KB
  rows:    3,854

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
2009-01-22 04:00:00	SPY	ETF	84.28	84.38	84.07	84.38	3400.0
2009-01-22 05:00:00	SPY	ETF	84.17	84.17	83.7	83.7	2800.0
2009-01-22 06:00:00	SPY	ETF	83.68	83.8	83.25	83.53	71899.0
2009-01-22 07:00:00	SPY	ETF	83.72	83.87	83.66	83.72	821304.0
2009-01-22 08:00:00	SPY	ETF	83.72	84.07	82.98	83.14	4508470.0
2009-01-22 09:00:00	SPY	ETF	83.15	83.17	82.06	82.408	41106383.0
2009-01-22 10:00:00	SPY	ETF	82.395	82.97	81.91	82.08	49041634.0
2009-01-22 11:00:00	SPY	ETF	82.08	82.38	81.21	81.3	48073146.0
2009-01-22 12:00:00	SPY	ETF	81.29	82.32	81.17	82.02	50532586.0
2009-01-22 13:00:00	SPY	ETF	82.03	82.98	81.711	82.98	48840982.0
2009-01-22 14:00:00	SPY	ETF	82.97	84.04	82.3	83.221	86711973.0
2009-01-22 15:00:00	SPY	ETF	83.22	83.4	82.0	82.78	78141105.0
2009-01-22 16:00:00	SPY	ETF	82.84	84.0935	82.13	82.83	16264784.0
2009-01-22 17:00:00	SPY	ETF	82.84	82.95	82.78	82.94	139898.0
2009-01-22 18:00:00	SPY	ETF	82.94	83.0	82.81	82.99	275499.0
2009-01-22 19:00:00	SPY	ETF	82.99	83.09	82.65	82.7	81497.0
2009-01-22 04:00:00	QQQ	ETF	29.41	29.46	29.37	29.46	400.0
2009-01-22 05:00:00	QQQ	ETF	29.32	29.32	29.21	29.21	6500.0
2009-01-22 06:00:00	QQQ	ETF	29.23	29.31	29.1	29.25	106100.0
2009-01-22 07:00:00	QQQ	ETF	29.26	29.36	29.25	29.28	421439.0
2009-01-22 08:00:00	QQQ	ETF	29.28	29.35	29.01	29.02	2998134.0
2009-01-22 09:00:00	QQQ	ETF	29.04	29.04	28.42	28.61	32257500.0
2009-01-22 10:00:00	QQQ	ETF	28.61	28.8	28.46	28.5	35629628.0
2009-01-22 11:00:00	QQQ	ETF	28.49	28.649	28.29	28.31	18313532.0
2009-01-22 12:00:00	QQQ	ETF	28.31	28.65	28.26	28.57	12552041.0
2009-01-22 13:00:00	QQQ	ETF	28.56	28.86	28.48	28.8515	18859866.0
2009-01-22 14:00:00	QQQ	ETF	28.85	29.23	28.78	28.9	33197343.0
2009-01-22 15:00:00	QQQ	ETF	28.89	28.93	28.52	28.77	32526697.0
2009-01-22 16:00:00	QQQ	ETF	28.76	29.15	28.63	28.83	8489087.0
2009-01-22 17:00:00	QQQ	ETF	28.84	28.88	28.8	28.88	49498.0
2009-01-22 18:00:00	QQQ	ETF	28.88	28.88	28.82	28.87	318100.0
2009-01-22 19:00:00	QQQ	ETF	28.87	28.87	28.76	28.76	31072.0
2009-01-22 06:00:00	IWM	ETF	45.26	45.26	45.12	45.22	435.0
2009-01-22 07:00:00	IWM	ETF	45.27	45.48	45.27	45.48	14001.0
2009-01-22 08:00:00	IWM	ETF	45.38	45.447	44.81	44.87	412663.0
2009-01-22 09:00:00	IWM	ETF	44.84	44.87	44.03	44.45	9594953.0
2009-01-22 10:00:00	IWM	ETF	44.41	44.74	44.01	44.17	10041134.0
2009-01-22 11:00:00	IWM	ETF	44.16	44.16	43.37	43.44	9140534.0
2009-01-22 12:00:00	IWM	ETF	43.44	44.16	43.4	43.98	6108776.0
2009-01-22 13:00:00	IWM	ETF	43.99	44.55	43.82	44.55	6425782.0
2009-01-22 14:00:00	IWM	ETF	44.55	45.33	44.24	44.629	10368495.0
2009-01-22 15:00:00	IWM	ETF	44.62	44.77	43.94	44.17	12090442.0
2009-01-22 16:00:00	IWM	ETF	44.16	45.5949	44.05	44.37	4204062.0
2009-01-22 17:00:00	IWM	ETF	44.41	44.41	44.41	44.41	100.0
2009-01-22 18:00:00	IWM	ETF	44.01	44.01	44.01	44.01	100.0
2009-01-22 04:00:00	DIA	ETF	81.36	81.36	81.36	81.36	500.0
2009-01-22 06:00:00	DIA	ETF	81.94	81.94	81.59	81.71	1700.0
2009-01-22 07:00:00	DIA	ETF	81.77	81.93	81.77	81.84	27350.0
2009-01-22 08:00:00	DIA	ETF	81.86	81.87	81.25	81.33	187302.0
2009-01-22 09:00:00	DIA	ETF	81.34	81.35	80.59	80.7	5523301.0

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

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