PREVIEW / etf_1hour / 2009-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-25.parquet
  size:    135 KB
  rows:    4,135

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-06-25 04:00:00	SPY	ETF	91.06	91.08	90.73	90.73	7145.0
2009-06-25 05:00:00	SPY	ETF	90.7	90.83	90.33	90.35	2466.0
2009-06-25 06:00:00	SPY	ETF	90.36	90.39	90.1	90.2	116650.0
2009-06-25 07:00:00	SPY	ETF	90.22	90.56	90.16	90.33	373008.0
2009-06-25 08:00:00	SPY	ETF	90.32	90.35	89.53	89.62	4418822.0
2009-06-25 09:00:00	SPY	ETF	89.62	90.5	89.57	90.41	30205118.0
2009-06-25 10:00:00	SPY	ETF	90.41	90.99	90.41	90.65	45547998.0
2009-06-25 11:00:00	SPY	ETF	90.65	91.76	90.57	91.72	31820195.0
2009-06-25 12:00:00	SPY	ETF	91.72	91.89	91.58	91.6	27244761.0
2009-06-25 13:00:00	SPY	ETF	91.6	92.17	91.56	91.93	25054504.0
2009-06-25 14:00:00	SPY	ETF	91.93	91.96	91.46	91.665	29545994.0
2009-06-25 15:00:00	SPY	ETF	91.67	92.06	91.37	92.03	54388607.0
2009-06-25 16:00:00	SPY	ETF	92.04	92.17	90.0837	92.03	15808013.0
2009-06-25 17:00:00	SPY	ETF	92.05	92.07	91.98	92.0	528963.0
2009-06-25 18:00:00	SPY	ETF	92.0	92.04	91.95	91.95	64456.0
2009-06-25 19:00:00	SPY	ETF	91.97	92.04	91.93	91.95	32154.0
2009-06-25 04:00:00	QQQ	ETF	35.87	35.87	35.84	35.84	1060.0
2009-06-25 05:00:00	QQQ	ETF	35.8	35.8	35.8	35.8	760.0
2009-06-25 06:00:00	QQQ	ETF	35.62	35.62	35.56	35.57	2162.0
2009-06-25 07:00:00	QQQ	ETF	35.6	35.74	35.6	35.66	77127.0
2009-06-25 08:00:00	QQQ	ETF	35.66	35.66	35.38	35.43	1113579.0
2009-06-25 09:00:00	QQQ	ETF	35.43	35.91	35.28	35.83	18799762.0
2009-06-25 10:00:00	QQQ	ETF	35.84	36.13	35.6	35.98	22126754.0
2009-06-25 11:00:00	QQQ	ETF	35.99	36.3	35.8	36.29	11413628.0
2009-06-25 12:00:00	QQQ	ETF	36.3	36.31	36.16	36.18	8712188.0
2009-06-25 13:00:00	QQQ	ETF	36.18	36.36	35.775	36.25	9118205.0
2009-06-25 14:00:00	QQQ	ETF	36.25	36.27	36.1	36.17	9581303.0
2009-06-25 15:00:00	QQQ	ETF	36.18	36.34	36.07	36.3	23551930.0
2009-06-25 16:00:00	QQQ	ETF	36.3	36.31	35.9733	36.25	3956386.0
2009-06-25 17:00:00	QQQ	ETF	36.26	36.29	36.25	36.28	7542.0
2009-06-25 18:00:00	QQQ	ETF	36.27	36.3	36.25	36.27	40809.0
2009-06-25 19:00:00	QQQ	ETF	36.26	36.26	36.23	36.23	6757.0
2009-06-25 06:00:00	IWM	ETF	49.61	49.61	49.61	49.61	800.0
2009-06-25 07:00:00	IWM	ETF	49.62	49.88	49.62	49.76	85262.0
2009-06-25 08:00:00	IWM	ETF	49.76	49.77	49.21	49.26	266415.0
2009-06-25 09:00:00	IWM	ETF	49.26	50.11	49.09	50.04	5533769.0
2009-06-25 10:00:00	IWM	ETF	50.03	50.27	49.94	50.02	6742512.0
2009-06-25 11:00:00	IWM	ETF	50.03	50.6	49.98	50.59	4901458.0
2009-06-25 12:00:00	IWM	ETF	50.6	50.64	50.44	50.44	3487158.0
2009-06-25 13:00:00	IWM	ETF	50.44	50.84	50.41	50.69	3800223.0
2009-06-25 14:00:00	IWM	ETF	50.69	50.73	50.44	50.66	4428120.0
2009-06-25 15:00:00	IWM	ETF	50.65	51.05	50.6	51.05	11866043.0
2009-06-25 16:00:00	IWM	ETF	51.051	51.15	50.4176	50.96	1062565.0
2009-06-25 17:00:00	IWM	ETF	50.94	51.01	50.93	51.01	1791.0
2009-06-25 18:00:00	IWM	ETF	50.96	51.05	50.93	50.99	2300.0
2009-06-25 19:00:00	IWM	ETF	50.95	51.0	50.95	51.0	700.0
2009-06-25 07:00:00	DIA	ETF	83.07	83.28	83.07	83.19	2343.0
2009-06-25 08:00:00	DIA	ETF	83.22	83.22	82.55	82.68	47888.0
2009-06-25 09:00:00	DIA	ETF	82.68	83.27	82.5704	83.2	2041766.0
2009-06-25 10:00:00	DIA	ETF	83.2	83.68	83.2	83.39	2407279.0

> showing 50 of 4,135 rows — these rows as CSV

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