PREVIEW / etf_1hour / 2007-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-05.parquet
  size:    92 KB
  rows:    3,088

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
2007-11-05 04:00:00	SPY	ETF	150.13	150.18	150.13	150.18	13200.0
2007-11-05 05:00:00	SPY	ETF	150.0	150.01	149.95	149.95	5600.0
2007-11-05 06:00:00	SPY	ETF	149.93	149.93	149.75	149.79	252200.0
2007-11-05 07:00:00	SPY	ETF	149.78	150.33	149.78	150.07	1281300.0
2007-11-05 08:00:00	SPY	ETF	150.08	150.09	149.48	149.77	4719700.0
2007-11-05 09:00:00	SPY	ETF	149.78	150.28	149.36	150.19	29404543.0
2007-11-05 10:00:00	SPY	ETF	150.2	150.78	149.91	150.39	33184886.0
2007-11-05 11:00:00	SPY	ETF	150.4	150.76	150.14	150.53	13330203.0
2007-11-05 12:00:00	SPY	ETF	150.53	150.66	150.05	150.28	10655639.0
2007-11-05 13:00:00	SPY	ETF	150.29	150.44	148.0	149.36	28426134.0
2007-11-05 14:00:00	SPY	ETF	149.38	149.88	148.97	149.56	40174926.0
2007-11-05 15:00:00	SPY	ETF	149.56	151.16	149.2	150.19	54211960.0
2007-11-05 16:00:00	SPY	ETF	150.15	150.9691	149.94	150.27	7863800.0
2007-11-05 17:00:00	SPY	ETF	150.29	150.75	150.2	150.65	33600.0
2007-11-05 18:00:00	SPY	ETF	150.22	150.26	149.22	150.12	13300.0
2007-11-05 19:00:00	SPY	ETF	150.13	150.4	150.1	150.4	79500.0
2007-11-05 04:00:00	QQQ	ETF	54.04	54.04	54.04	54.04	100.0
2007-11-05 05:00:00	QQQ	ETF	54.04	54.04	54.0	54.01	12400.0
2007-11-05 06:00:00	QQQ	ETF	53.91	53.98	53.91	53.96	153600.0
2007-11-05 07:00:00	QQQ	ETF	53.92	54.06	53.92	54.0	280800.0
2007-11-05 08:00:00	QQQ	ETF	53.98	54.0	53.85	53.91	1029015.0
2007-11-05 09:00:00	QQQ	ETF	53.9	54.04	53.63	54.02	23938601.0
2007-11-05 10:00:00	QQQ	ETF	54.02	54.4	53.99	54.24	25203527.0
2007-11-05 11:00:00	QQQ	ETF	54.24	54.32	54.08	54.25	12176947.0
2007-11-05 12:00:00	QQQ	ETF	54.26	54.3	54.06	54.12	6908891.0
2007-11-05 13:00:00	QQQ	ETF	54.12	54.19	53.75	53.81	14601038.0
2007-11-05 14:00:00	QQQ	ETF	53.82	53.95	53.59	53.78	25968661.0
2007-11-05 15:00:00	QQQ	ETF	53.772	54.36	53.77	54.09	30152748.0
2007-11-05 16:00:00	QQQ	ETF	54.08	54.21	54.0175	54.21	10223097.0
2007-11-05 17:00:00	QQQ	ETF	54.17	54.22	54.1	54.22	23234.0
2007-11-05 18:00:00	QQQ	ETF	54.18	54.18	54.12	54.12	6199.0
2007-11-05 19:00:00	QQQ	ETF	54.13	54.2	54.13	54.2	11956.0
2007-11-05 05:00:00	IWM	ETF	78.57	78.57	78.57	78.57	100.0
2007-11-05 06:00:00	IWM	ETF	78.57	78.6	78.54	78.54	7400.0
2007-11-05 07:00:00	IWM	ETF	78.59	78.87	78.59	78.86	145000.0
2007-11-05 08:00:00	IWM	ETF	78.77	78.83	78.35	78.43	442700.0
2007-11-05 09:00:00	IWM	ETF	78.43	78.7	78.21	78.64	14365364.0
2007-11-05 10:00:00	IWM	ETF	78.64	79.07	78.39	78.79	13447594.0
2007-11-05 11:00:00	IWM	ETF	78.78	78.94	78.48	78.76	7049288.0
2007-11-05 12:00:00	IWM	ETF	78.76	78.83	78.35	78.72	9478965.0
2007-11-05 13:00:00	IWM	ETF	78.71	78.79	78.08	78.29	9874778.0
2007-11-05 14:00:00	IWM	ETF	78.3	78.58	78.05	78.37	10792312.0
2007-11-05 15:00:00	IWM	ETF	78.37	79.23	78.36	78.64	18005330.0
2007-11-05 16:00:00	IWM	ETF	78.64	79.21	78.35	78.56	14892407.0
2007-11-05 17:00:00	IWM	ETF	78.57	78.85	78.52	78.52	3200.0
2007-11-05 18:00:00	IWM	ETF	78.65	78.92	78.56	78.63	3600.0
2007-11-05 19:00:00	IWM	ETF	78.52	78.68	78.5	78.68	35000.0
2007-11-05 06:00:00	DIA	ETF	133.8	133.8	133.8	133.8	1100.0
2007-11-05 07:00:00	DIA	ETF	133.8	135.13	133.8	135.13	4100.0
2007-11-05 08:00:00	DIA	ETF	135.1	135.12	134.78	134.93	90400.0

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

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