PREVIEW / etf_1hour / 2008-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-25.parquet
  size:    101 KB
  rows:    3,367

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
2008-03-25 05:00:00	SPY	ETF	134.57	134.58	134.5	134.56	17600.0
2008-03-25 06:00:00	SPY	ETF	134.56	135.27	134.56	135.24	154000.0
2008-03-25 07:00:00	SPY	ETF	135.16	135.62	135.16	135.45	747900.0
2008-03-25 08:00:00	SPY	ETF	135.45	135.61	134.7	134.77	3349500.0
2008-03-25 09:00:00	SPY	ETF	134.75	135.33	134.25	134.3	26185914.0
2008-03-25 10:00:00	SPY	ETF	134.27	135.0	133.77	134.4	40085279.0
2008-03-25 11:00:00	SPY	ETF	134.4	134.93	134.28	134.46	19567864.0
2008-03-25 12:00:00	SPY	ETF	134.48	135.22	134.32	134.94	19259391.0
2008-03-25 13:00:00	SPY	ETF	134.94	135.49	134.77	135.43	13969321.0
2008-03-25 14:00:00	SPY	ETF	135.43	135.55	134.96	135.39	16784734.0
2008-03-25 15:00:00	SPY	ETF	135.39	135.55	134.82	135.05	39569562.0
2008-03-25 16:00:00	SPY	ETF	135.05	135.54	134.7	134.7	10772000.0
2008-03-25 17:00:00	SPY	ETF	134.7	134.73	134.56	134.65	83300.0
2008-03-25 18:00:00	SPY	ETF	134.65	134.7	134.55	134.7	15300.0
2008-03-25 19:00:00	SPY	ETF	134.66	134.66	134.41	134.49	69500.0
2008-03-25 05:00:00	QQQ	ETF	44.56	44.56	44.5	44.5	1400.0
2008-03-25 07:00:00	QQQ	ETF	44.72	44.84	44.72	44.81	93494.0
2008-03-25 08:00:00	QQQ	ETF	44.81	44.84	44.68	44.68	1915173.0
2008-03-25 09:00:00	QQQ	ETF	44.69	44.83	44.43	44.44	16694931.0
2008-03-25 10:00:00	QQQ	ETF	44.44	44.67	44.28	44.55	24523960.0
2008-03-25 11:00:00	QQQ	ETF	44.56	44.74	44.5	44.532	13348308.0
2008-03-25 12:00:00	QQQ	ETF	44.54	44.77	44.48	44.65	9017097.0
2008-03-25 13:00:00	QQQ	ETF	44.66	44.99	44.57	44.95	13099142.0
2008-03-25 14:00:00	QQQ	ETF	44.95	45.0	44.8	44.99	10547592.0
2008-03-25 15:00:00	QQQ	ETF	44.99	45.07	44.81	44.83	13653315.0
2008-03-25 16:00:00	QQQ	ETF	44.84	44.855	44.6193	44.77	11643953.0
2008-03-25 17:00:00	QQQ	ETF	44.75	44.76	44.72	44.76	40493.0
2008-03-25 18:00:00	QQQ	ETF	44.74	44.94	44.67	44.75	84830.0
2008-03-25 19:00:00	QQQ	ETF	44.73	44.73	44.68	44.72	28724.0
2008-03-25 07:00:00	IWM	ETF	70.29	70.3	70.19	70.3	36000.0
2008-03-25 08:00:00	IWM	ETF	70.36	70.36	69.99	69.99	415100.0
2008-03-25 09:00:00	IWM	ETF	70.01	70.28	69.48	69.7	14102020.0
2008-03-25 10:00:00	IWM	ETF	69.7	70.02	69.28	69.88	18285616.0
2008-03-25 11:00:00	IWM	ETF	69.87	70.16	69.56	69.62	8553907.0
2008-03-25 12:00:00	IWM	ETF	69.62	70.17	69.53	70.05	4466687.0
2008-03-25 13:00:00	IWM	ETF	70.04	70.37	69.94	70.3	5023709.0
2008-03-25 14:00:00	IWM	ETF	70.29	70.43	69.99	70.28	7642919.0
2008-03-25 15:00:00	IWM	ETF	70.28	70.34	70.05	70.3	9170708.0
2008-03-25 16:00:00	IWM	ETF	70.31	70.34	69.8	70.16	1480800.0
2008-03-25 17:00:00	IWM	ETF	70.16	70.2	70.04	70.04	42000.0
2008-03-25 18:00:00	IWM	ETF	70.09	70.14	70.08	70.14	23100.0
2008-03-25 08:00:00	DIA	ETF	125.82	125.82	125.22	125.22	63200.0
2008-03-25 09:00:00	DIA	ETF	125.19	125.61	124.8	124.87	1695185.0
2008-03-25 10:00:00	DIA	ETF	124.8	124.86	124.4	124.67	2823539.0
2008-03-25 11:00:00	DIA	ETF	124.68	125.07	124.59	124.69	1012250.0
2008-03-25 12:00:00	DIA	ETF	124.7	125.31	124.56	125.13	1126740.0
2008-03-25 13:00:00	DIA	ETF	125.1	125.56	124.96	125.53	1147692.0
2008-03-25 14:00:00	DIA	ETF	125.52	125.55	125.08	125.47	1848199.0
2008-03-25 15:00:00	DIA	ETF	125.47	125.6	125.02	125.23	1867318.0
2008-03-25 16:00:00	DIA	ETF	125.23	125.23	125.04	125.04	168700.0

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

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