PREVIEW / etf_1hour / 2007-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-13.parquet
  size:    94 KB
  rows:    3,162

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-12-13 04:00:00	SPY	ETF	148.6	148.6	148.34	148.35	5500.0
2007-12-13 05:00:00	SPY	ETF	148.65	149.0	148.65	148.98	15700.0
2007-12-13 06:00:00	SPY	ETF	148.88	148.88	148.61	148.61	111000.0
2007-12-13 07:00:00	SPY	ETF	148.64	148.64	147.58	148.1	1419400.0
2007-12-13 08:00:00	SPY	ETF	148.1	149.3	147.42	148.3	8695026.0
2007-12-13 09:00:00	SPY	ETF	148.32	149.0	147.77	147.94	26116568.0
2007-12-13 10:00:00	SPY	ETF	147.94	148.69	147.44	147.58	41117418.0
2007-12-13 11:00:00	SPY	ETF	147.58	148.09	147.3	147.99	34336049.0
2007-12-13 12:00:00	SPY	ETF	147.99	148.16	147.46	147.68	16429049.0
2007-12-13 13:00:00	SPY	ETF	147.65	148.09	147.51	147.94	15795398.0
2007-12-13 14:00:00	SPY	ETF	147.94	148.78	147.68	148.33	33891095.0
2007-12-13 15:00:00	SPY	ETF	148.32	149.39	147.97	149.31	45864005.0
2007-12-13 16:00:00	SPY	ETF	149.2501	149.39	148.0574	148.99	8468800.0
2007-12-13 17:00:00	SPY	ETF	148.99	149.1	148.94	149.03	256200.0
2007-12-13 18:00:00	SPY	ETF	149.03	149.28	149.01	149.27	33900.0
2007-12-13 19:00:00	SPY	ETF	149.25	149.48	149.22	149.39	21300.0
2007-12-13 05:00:00	QQQ	ETF	51.46	51.6	51.46	51.6	300.0
2007-12-13 06:00:00	QQQ	ETF	51.55	51.58	51.53	51.57	33500.0
2007-12-13 07:00:00	QQQ	ETF	51.52	51.53	51.16	51.31	669493.0
2007-12-13 08:00:00	QQQ	ETF	51.3	51.45	51.09	51.41	3380735.0
2007-12-13 09:00:00	QQQ	ETF	51.42	51.63	51.2	51.26	18881033.0
2007-12-13 10:00:00	QQQ	ETF	51.26	51.48	51.01	51.07	29191979.0
2007-12-13 11:00:00	QQQ	ETF	51.075	51.23	51.02	51.23	25382991.0
2007-12-13 12:00:00	QQQ	ETF	51.24	51.28	51.03	51.1	13997456.0
2007-12-13 13:00:00	QQQ	ETF	51.1	51.23	50.98	51.08	11462629.0
2007-12-13 14:00:00	QQQ	ETF	51.0886	51.36	51.01	51.25	17252424.0
2007-12-13 15:00:00	QQQ	ETF	51.25	51.6	51.15	51.51	29482584.0
2007-12-13 16:00:00	QQQ	ETF	51.5	51.5675	51.38	51.38	3973946.0
2007-12-13 17:00:00	QQQ	ETF	51.39	51.43	51.38	51.42	81270.0
2007-12-13 18:00:00	QQQ	ETF	51.42	51.47	51.42	51.47	119000.0
2007-12-13 19:00:00	QQQ	ETF	51.47	51.53	51.46	51.51	73443.0
2007-12-13 06:00:00	IWM	ETF	76.72	76.72	76.64	76.64	38000.0
2007-12-13 07:00:00	IWM	ETF	76.57	76.57	76.15	76.21	158500.0
2007-12-13 08:00:00	IWM	ETF	76.25	76.6	75.86	76.27	839800.0
2007-12-13 09:00:00	IWM	ETF	76.3	76.67	75.8	76.05	12187362.0
2007-12-13 10:00:00	IWM	ETF	76.05	76.36	75.84	75.93	10170937.0
2007-12-13 11:00:00	IWM	ETF	75.93	76.1	75.66	75.88	10862192.0
2007-12-13 12:00:00	IWM	ETF	75.88	76.0	75.64	75.78	5981800.0
2007-12-13 13:00:00	IWM	ETF	75.78	76.12	75.75	76.02	5786000.0
2007-12-13 14:00:00	IWM	ETF	76.0	76.72	75.86	76.31	12790900.0
2007-12-13 15:00:00	IWM	ETF	76.31	76.89	76.11	76.65	15049000.0
2007-12-13 16:00:00	IWM	ETF	76.64	76.98	76.22	76.4	15922775.0
2007-12-13 17:00:00	IWM	ETF	76.4	76.45	76.37	76.4	40500.0
2007-12-13 18:00:00	IWM	ETF	76.48	76.52	76.48	76.52	5200.0
2007-12-13 19:00:00	IWM	ETF	76.52	76.59	76.52	76.58	2400.0
2007-12-13 06:00:00	DIA	ETF	137.99	137.99	137.99	137.99	100.0
2007-12-13 07:00:00	DIA	ETF	134.04	134.06	133.96	134.05	12200.0
2007-12-13 08:00:00	DIA	ETF	134.1	134.41	133.76	134.28	61400.0
2007-12-13 09:00:00	DIA	ETF	134.32	134.91	134.1	134.22	1469234.0
2007-12-13 10:00:00	DIA	ETF	134.23	134.82	133.77	133.9	2810300.0

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

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