PREVIEW / etf_1hour / 2009-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-30.parquet
  size:    127 KB
  rows:    3,895

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-30 04:00:00	SPY	ETF	85.2	85.2	85.01	85.01	200.0
2009-01-30 05:00:00	SPY	ETF	84.7	84.83	84.7	84.83	300.0
2009-01-30 06:00:00	SPY	ETF	85.11	85.11	84.54	84.6	93300.0
2009-01-30 07:00:00	SPY	ETF	84.49	84.54	83.75	83.81	1103034.0
2009-01-30 08:00:00	SPY	ETF	83.82	85.1	83.82	84.91	11494759.0
2009-01-30 09:00:00	SPY	ETF	84.9	85.4	84.23	84.23	41727728.0
2009-01-30 10:00:00	SPY	ETF	84.23	84.6	83.28	83.59	56448994.0
2009-01-30 11:00:00	SPY	ETF	83.58	83.86	82.95	83.4	37816909.0
2009-01-30 12:00:00	SPY	ETF	83.4	83.87	83.16	83.8	24462535.0
2009-01-30 13:00:00	SPY	ETF	83.8	84.22	82.77	83.27	54066672.0
2009-01-30 14:00:00	SPY	ETF	83.27	83.69	82.93	83.12	35930522.0
2009-01-30 15:00:00	SPY	ETF	83.12	83.38	82.21	82.69	85533292.0
2009-01-30 16:00:00	SPY	ETF	82.76	84.5976	82.65	83.04	30573331.0
2009-01-30 17:00:00	SPY	ETF	83.02	83.1	82.89	82.97	790612.0
2009-01-30 18:00:00	SPY	ETF	82.97	83.34	82.95	83.17	108171.0
2009-01-30 19:00:00	SPY	ETF	83.09	83.15	83.02	83.03	31439.0
2009-01-30 04:00:00	QQQ	ETF	29.85	29.89	29.84	29.89	6900.0
2009-01-30 05:00:00	QQQ	ETF	29.84	29.84	29.84	29.84	500.0
2009-01-30 06:00:00	QQQ	ETF	29.75	29.75	29.66	29.66	5700.0
2009-01-30 07:00:00	QQQ	ETF	29.63	29.63	29.43	29.44	135106.0
2009-01-30 08:00:00	QQQ	ETF	29.46	29.88	29.44	29.82	1779541.0
2009-01-30 09:00:00	QQQ	ETF	29.82	29.93	29.53	29.53	15471520.0
2009-01-30 10:00:00	QQQ	ETF	29.52	29.57	29.19	29.32	18606267.0
2009-01-30 11:00:00	QQQ	ETF	29.32	29.42	29.07	29.18	16621763.0
2009-01-30 12:00:00	QQQ	ETF	29.18	29.35	29.11	29.34	10723854.0
2009-01-30 13:00:00	QQQ	ETF	29.34	29.53	29.13	29.3001	18741262.0
2009-01-30 14:00:00	QQQ	ETF	29.3	29.44	29.17	29.21	13952716.0
2009-01-30 15:00:00	QQQ	ETF	29.2	29.3	28.94	29.03	33908599.0
2009-01-30 16:00:00	QQQ	ETF	29.03	29.14	29.0272	29.11	5794489.0
2009-01-30 17:00:00	QQQ	ETF	29.11	29.6116	29.07	29.12	1072368.0
2009-01-30 18:00:00	QQQ	ETF	29.09	29.17	29.09	29.09	11498.0
2009-01-30 19:00:00	QQQ	ETF	29.15	29.17	29.08	29.16	15038.0
2009-01-30 07:00:00	IWM	ETF	45.44	45.44	45.04	45.04	41700.0
2009-01-30 08:00:00	IWM	ETF	45.07	45.86	45.02	45.78	751387.0
2009-01-30 09:00:00	IWM	ETF	45.78	46.01	45.24	45.24	5386663.0
2009-01-30 10:00:00	IWM	ETF	45.24	45.32	44.64	44.84	9031591.0
2009-01-30 11:00:00	IWM	ETF	44.84	44.97	44.42	44.57	4953752.0
2009-01-30 12:00:00	IWM	ETF	44.58	45.12	44.45	45.09	4051468.0
2009-01-30 13:00:00	IWM	ETF	45.09	45.32	44.36	44.67	7718143.0
2009-01-30 14:00:00	IWM	ETF	44.66	46.0	44.4	44.53	5567534.0
2009-01-30 15:00:00	IWM	ETF	44.53	44.77	44.11	44.43	17206741.0
2009-01-30 16:00:00	IWM	ETF	44.42	44.75	44.271	44.53	2759754.0
2009-01-30 18:00:00	IWM	ETF	44.61	44.61	44.58	44.58	200.0
2009-01-30 19:00:00	IWM	ETF	44.61	44.61	44.5	44.61	500.0
2009-01-30 06:00:00	DIA	ETF	81.59	81.62	81.54	81.54	2330.0
2009-01-30 07:00:00	DIA	ETF	81.4	81.41	80.86	80.88	10534.0
2009-01-30 08:00:00	DIA	ETF	80.91	82.0	80.91	81.72	75448.0
2009-01-30 09:00:00	DIA	ETF	81.71	81.96	81.17	81.1708	2603894.0
2009-01-30 10:00:00	DIA	ETF	81.16	81.24	80.37	80.65	4407186.0
2009-01-30 11:00:00	DIA	ETF	80.64	80.83	80.07	80.42	3218280.0

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

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