PREVIEW / etf_1hour / 2007-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-13.parquet
  size:    81 KB
  rows:    2,692

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-06-13 04:00:00	SPY	ETF	149.76	149.76	149.76	149.76	6100.0
2007-06-13 05:00:00	SPY	ETF	149.59	149.59	149.36	149.48	29300.0
2007-06-13 06:00:00	SPY	ETF	149.56	149.84	149.56	149.8	40000.0
2007-06-13 07:00:00	SPY	ETF	149.81	150.09	149.78	150.07	637600.0
2007-06-13 08:00:00	SPY	ETF	150.04	150.52	149.54	150.42	9388100.0
2007-06-13 09:00:00	SPY	ETF	150.4	150.71	149.25	150.41	13746400.0
2007-06-13 10:00:00	SPY	ETF	150.41	151.02	150.21	150.79	25676500.0
2007-06-13 11:00:00	SPY	ETF	150.79	150.87	150.4	150.62	13436600.0
2007-06-13 12:00:00	SPY	ETF	150.63	150.85	150.41	150.45	12706200.0
2007-06-13 13:00:00	SPY	ETF	150.46	150.63	150.19	150.6	13241526.0
2007-06-13 14:00:00	SPY	ETF	150.6	151.67	150.58	151.6225	61740810.0
2007-06-13 15:00:00	SPY	ETF	151.61	151.98	150.51	151.95	32309200.0
2007-06-13 16:00:00	SPY	ETF	151.97	152.06	151.8	151.86	5313700.0
2007-06-13 17:00:00	SPY	ETF	151.87	151.995	151.8	151.8	2176400.0
2007-06-13 18:00:00	SPY	ETF	151.85	151.85	151.75	151.85	32600.0
2007-06-13 19:00:00	SPY	ETF	151.85	151.93	151.83	151.93	5000.0
2007-06-13 06:00:00	QQQ	ETF	46.57	46.58	46.57	46.58	15000.0
2007-06-13 07:00:00	QQQ	ETF	46.56	46.7	46.56	46.7	266381.0
2007-06-13 08:00:00	QQQ	ETF	46.67	46.82	46.48	46.75	6434806.0
2007-06-13 09:00:00	QQQ	ETF	46.76	46.85	46.54	46.72	14675138.0
2007-06-13 10:00:00	QQQ	ETF	46.72	46.88	46.66	46.79	18622092.0
2007-06-13 11:00:00	QQQ	ETF	46.7815	46.8	46.65	46.7	11897635.0
2007-06-13 12:00:00	QQQ	ETF	46.7	46.74	46.58	46.64	16054129.0
2007-06-13 13:00:00	QQQ	ETF	46.6515	46.68	46.56	46.67	14369987.0
2007-06-13 14:00:00	QQQ	ETF	46.67	46.94	46.65	46.92	16618245.0
2007-06-13 15:00:00	QQQ	ETF	46.92	47.09	46.83	47.06	37440658.0
2007-06-13 16:00:00	QQQ	ETF	47.06	47.1	46.9815	47.04	8227056.0
2007-06-13 17:00:00	QQQ	ETF	47.04	47.09	46.79	47.01	797549.0
2007-06-13 18:00:00	QQQ	ETF	47.01	47.02	47.01	47.02	3730.0
2007-06-13 19:00:00	QQQ	ETF	47.04	47.07	47.03	47.07	29335.0
2007-06-13 07:00:00	IWM	ETF	81.67	81.75	81.6	81.74	57100.0
2007-06-13 08:00:00	IWM	ETF	81.6	82.01	81.47	82.0	2301100.0
2007-06-13 09:00:00	IWM	ETF	81.92	82.08	81.8	81.98	10690000.0
2007-06-13 10:00:00	IWM	ETF	81.98	82.36	81.74	82.24	18843500.0
2007-06-13 11:00:00	IWM	ETF	82.22	82.29	82.05	82.25	4501200.0
2007-06-13 12:00:00	IWM	ETF	82.25	82.44	82.13	82.24	5488500.0
2007-06-13 13:00:00	IWM	ETF	82.24	82.3	82.07	82.24	6302500.0
2007-06-13 14:00:00	IWM	ETF	82.24	82.97	82.23	82.91	19392300.0
2007-06-13 15:00:00	IWM	ETF	82.91	82.94	82.53	82.71	17888500.0
2007-06-13 16:00:00	IWM	ETF	82.71	82.8	82.56	82.6	1676300.0
2007-06-13 17:00:00	IWM	ETF	82.63	82.7827	82.53	82.53	3370300.0
2007-06-13 18:00:00	IWM	ETF	82.59	82.59	82.58	82.58	300.0
2007-06-13 19:00:00	IWM	ETF	82.57	82.6	82.57	82.6	900.0
2007-06-13 07:00:00	DIA	ETF	133.27	133.36	133.23	133.36	7400.0
2007-06-13 08:00:00	DIA	ETF	133.33	133.7	133.0	133.64	45700.0
2007-06-13 09:00:00	DIA	ETF	133.58	133.79	133.47	133.6	1510400.0
2007-06-13 10:00:00	DIA	ETF	133.6	134.08	133.38	133.88	3449500.0
2007-06-13 11:00:00	DIA	ETF	133.86	133.93	133.54	133.65	1601900.0
2007-06-13 12:00:00	DIA	ETF	133.66	133.78	133.46	133.5	1133100.0
2007-06-13 13:00:00	DIA	ETF	133.5	133.63	133.24	133.61	1752701.0

> showing 50 of 2,692 rows — these rows as CSV

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