PREVIEW / etf_1hour / 2007-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-09.parquet
  size:    89 KB
  rows:    2,969

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-08-09 04:00:00	SPY	ETF	149.11	149.11	148.66	148.68	35000.0
2007-08-09 05:00:00	SPY	ETF	148.63	148.99	148.5	148.6	34000.0
2007-08-09 06:00:00	SPY	ETF	148.69	148.81	148.23	148.29	77900.0
2007-08-09 07:00:00	SPY	ETF	148.24	148.66	148.17	148.52	2615200.0
2007-08-09 08:00:00	SPY	ETF	148.48	148.68	147.54	147.63	9897900.0
2007-08-09 09:00:00	SPY	ETF	147.63	147.97	146.75	147.78	53889360.0
2007-08-09 10:00:00	SPY	ETF	147.78	149.9	147.65	148.12	59940561.0
2007-08-09 11:00:00	SPY	ETF	148.12	148.84	147.63	148.07	33220228.0
2007-08-09 12:00:00	SPY	ETF	148.07	148.19	147.13	147.42	31733122.0
2007-08-09 13:00:00	SPY	ETF	147.42	147.79	146.7	147.6	38215223.0
2007-08-09 14:00:00	SPY	ETF	147.62	147.96	146.32	146.34	35628235.0
2007-08-09 15:00:00	SPY	ETF	146.34	149.95	145.64	145.7	67553533.0
2007-08-09 16:00:00	SPY	ETF	145.65	148.67	145.29	145.41	9492700.0
2007-08-09 17:00:00	SPY	ETF	145.39	147.0	145.25	145.44	750000.0
2007-08-09 18:00:00	SPY	ETF	145.44	145.56	145.33	145.46	134700.0
2007-08-09 19:00:00	SPY	ETF	145.47	145.51	144.52	144.6	532400.0
2007-08-09 06:00:00	QQQ	ETF	48.65	48.65	48.65	48.65	5000.0
2007-08-09 07:00:00	QQQ	ETF	48.54	48.66	48.47	48.58	1069703.0
2007-08-09 08:00:00	QQQ	ETF	48.57	48.63	48.18	48.25	5605741.0
2007-08-09 09:00:00	QQQ	ETF	48.26	48.57	48.08	48.53	29890242.0
2007-08-09 10:00:00	QQQ	ETF	48.54	48.97	48.48	48.71	36022693.0
2007-08-09 11:00:00	QQQ	ETF	48.71	48.87	48.41	48.52	21261465.0
2007-08-09 12:00:00	QQQ	ETF	48.52	48.58	48.12	48.23	28812062.0
2007-08-09 13:00:00	QQQ	ETF	48.23	48.4	48.06	48.3286	29798168.0
2007-08-09 14:00:00	QQQ	ETF	48.32	48.32	47.93	47.93	36781839.0
2007-08-09 15:00:00	QQQ	ETF	47.93	48.05	47.69	47.6985	35512549.0
2007-08-09 16:00:00	QQQ	ETF	47.691	47.75	47.5	47.66	5507167.0
2007-08-09 17:00:00	QQQ	ETF	47.66	47.74	47.53	47.55	436283.0
2007-08-09 18:00:00	QQQ	ETF	47.58	47.61	47.55	47.59	339478.0
2007-08-09 19:00:00	QQQ	ETF	47.59	47.71	47.34	47.43	430640.0
2007-08-09 04:00:00	IWM	ETF	79.22	79.22	79.22	79.22	500.0
2007-08-09 06:00:00	IWM	ETF	78.78	78.78	78.63	78.63	25000.0
2007-08-09 07:00:00	IWM	ETF	78.69	78.79	78.5	78.63	269700.0
2007-08-09 08:00:00	IWM	ETF	78.61	78.76	77.9	77.9	4039300.0
2007-08-09 09:00:00	IWM	ETF	77.92	78.43	77.53	78.24	27080943.0
2007-08-09 10:00:00	IWM	ETF	78.24	79.41	78.22	78.87	33209690.0
2007-08-09 11:00:00	IWM	ETF	78.87	79.23	78.66	79.04	20685918.0
2007-08-09 12:00:00	IWM	ETF	79.04	79.29	78.53	78.57	23416900.0
2007-08-09 13:00:00	IWM	ETF	78.57	78.74	77.99	78.53	23222517.0
2007-08-09 14:00:00	IWM	ETF	78.52	78.65	77.88	77.95	20304905.0
2007-08-09 15:00:00	IWM	ETF	77.96	78.47	77.1	78.01	30602904.0
2007-08-09 16:00:00	IWM	ETF	78.02	78.7	77.62	77.69	4639100.0
2007-08-09 17:00:00	IWM	ETF	77.67	77.69	77.45	77.69	2157800.0
2007-08-09 18:00:00	IWM	ETF	77.6	77.62	77.59	77.59	15200.0
2007-08-09 19:00:00	IWM	ETF	77.69	77.69	77.32	77.43	166400.0
2007-08-09 07:00:00	DIA	ETF	135.51	135.68	135.27	135.5	136900.0
2007-08-09 08:00:00	DIA	ETF	135.51	135.63	134.72	134.72	749300.0
2007-08-09 09:00:00	DIA	ETF	134.73	135.09	134.22	134.88	4962100.0
2007-08-09 10:00:00	DIA	ETF	134.92	135.8	134.76	135.26	4462800.0
2007-08-09 11:00:00	DIA	ETF	135.27	135.82	135.02	135.38	4383200.0

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

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