PREVIEW / etf_1hour / 2007-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-19.parquet
  size:    93 KB
  rows:    3,110

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-10-19 04:00:00	SPY	ETF	152.96	152.96	152.96	152.96	1500.0
2007-10-19 05:00:00	SPY	ETF	152.96	153.08	152.88	153.08	39600.0
2007-10-19 06:00:00	SPY	ETF	153.22	153.4	153.18	153.39	53500.0
2007-10-19 07:00:00	SPY	ETF	153.41	153.5	153.22	153.31	982500.0
2007-10-19 08:00:00	SPY	ETF	153.36	153.51	152.92	153.32	4684600.0
2007-10-19 09:00:00	SPY	ETF	153.32	156.48	152.6	152.87	21848364.0
2007-10-19 10:00:00	SPY	ETF	152.87	153.012	151.58	151.61	49803000.0
2007-10-19 11:00:00	SPY	ETF	151.61	153.12	151.39	152.11	38769800.0
2007-10-19 12:00:00	SPY	ETF	152.1	152.3	151.83	151.89	18908896.0
2007-10-19 13:00:00	SPY	ETF	151.88	151.95	151.43	151.73	21707100.0
2007-10-19 14:00:00	SPY	ETF	151.73	151.73	150.75	150.859	42129206.0
2007-10-19 15:00:00	SPY	ETF	150.85	153.9137	149.9	149.97	76715800.0
2007-10-19 16:00:00	SPY	ETF	149.98	153.9137	149.56	149.65	12496700.0
2007-10-19 17:00:00	SPY	ETF	149.6	153.9137	149.4	149.41	1777300.0
2007-10-19 18:00:00	SPY	ETF	149.45	151.54	149.27	149.39	48100.0
2007-10-19 19:00:00	SPY	ETF	149.39	149.59	149.37	149.43	19000.0
2007-10-19 05:00:00	QQQ	ETF	53.74	53.74	53.7	53.7	8000.0
2007-10-19 06:00:00	QQQ	ETF	53.72	53.88	53.72	53.87	16000.0
2007-10-19 07:00:00	QQQ	ETF	53.93	54.1	53.89	53.95	833505.0
2007-10-19 08:00:00	QQQ	ETF	53.95	54.1	53.53	53.88	3653897.0
2007-10-19 09:00:00	QQQ	ETF	53.88	53.88	53.38	53.45	29821302.0
2007-10-19 10:00:00	QQQ	ETF	53.45	53.47	52.72	52.74	37253109.0
2007-10-19 11:00:00	QQQ	ETF	52.74	53.16	52.74	53.09	31392505.0
2007-10-19 12:00:00	QQQ	ETF	53.0995	53.19	52.98	53.018	32525839.0
2007-10-19 13:00:00	QQQ	ETF	53.01	53.08	52.8	52.97	21940218.0
2007-10-19 14:00:00	QQQ	ETF	52.972	53.03	52.73	52.79	26115007.0
2007-10-19 15:00:00	QQQ	ETF	52.82	52.88	52.39	52.43	53404971.0
2007-10-19 16:00:00	QQQ	ETF	52.42	53.7727	52.37	52.39	10795751.0
2007-10-19 17:00:00	QQQ	ETF	52.39	52.46	52.36	52.36	76932.0
2007-10-19 18:00:00	QQQ	ETF	52.39	52.9561	52.29	52.35	109200.0
2007-10-19 19:00:00	QQQ	ETF	52.39	52.39	52.35	52.35	7800.0
2007-10-19 04:00:00	IWM	ETF	81.66	81.66	81.66	81.66	200.0
2007-10-19 06:00:00	IWM	ETF	81.75	81.89	81.75	81.81	13500.0
2007-10-19 07:00:00	IWM	ETF	81.8	81.92	81.8	81.92	1500.0
2007-10-19 08:00:00	IWM	ETF	81.89	81.96	81.74	81.95	101900.0
2007-10-19 09:00:00	IWM	ETF	81.95	82.12	81.05	81.32	16722695.0
2007-10-19 10:00:00	IWM	ETF	81.32	81.37	80.61	80.64	16604400.0
2007-10-19 11:00:00	IWM	ETF	80.63	81.18	80.6	81.08	15406800.0
2007-10-19 12:00:00	IWM	ETF	81.07	81.2	80.87	80.96	7440400.0
2007-10-19 13:00:00	IWM	ETF	80.95	81.69	80.68	80.86	8588200.0
2007-10-19 14:00:00	IWM	ETF	80.86	80.86	80.08	80.11	16461600.0
2007-10-19 15:00:00	IWM	ETF	80.11	80.25	79.0	79.45	41619800.0
2007-10-19 16:00:00	IWM	ETF	79.44	79.75	78.99	79.2	7046900.0
2007-10-19 17:00:00	IWM	ETF	79.1	79.1	79.1	79.1	1900.0
2007-10-19 18:00:00	IWM	ETF	79.01	79.01	78.89	78.89	5500.0
2007-10-19 19:00:00	IWM	ETF	78.89	79.09	78.89	79.09	500.0
2007-10-19 07:00:00	DIA	ETF	138.46	138.52	138.37	138.52	5300.0
2007-10-19 08:00:00	DIA	ETF	138.42	138.43	138.15	138.23	129000.0
2007-10-19 09:00:00	DIA	ETF	138.27	138.27	137.41	137.68	4260400.0
2007-10-19 10:00:00	DIA	ETF	137.69	137.76	136.46	136.51	5368800.0

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

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