PREVIEW / etf_1hour / 2007-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-13.parquet
  size:    93 KB
  rows:    3,104

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-13 05:00:00	SPY	ETF	144.53	144.65	144.53	144.65	14300.0
2007-11-13 06:00:00	SPY	ETF	144.65	145.07	144.65	144.74	327900.0
2007-11-13 07:00:00	SPY	ETF	144.73	145.13	144.69	145.06	1359700.0
2007-11-13 08:00:00	SPY	ETF	145.06	145.18	144.66	145.08	4685700.0
2007-11-13 09:00:00	SPY	ETF	145.08	146.03	145.08	145.59	30694334.0
2007-11-13 10:00:00	SPY	ETF	145.6	146.04	145.38	145.57	27490244.0
2007-11-13 11:00:00	SPY	ETF	145.57	146.34	145.5	145.93	22047568.0
2007-11-13 12:00:00	SPY	ETF	145.93	146.13	145.72	145.86	13423314.0
2007-11-13 13:00:00	SPY	ETF	145.86	146.71	145.65	146.5	19028610.0
2007-11-13 14:00:00	SPY	ETF	146.49	147.15	146.39	147.0	19912327.0
2007-11-13 15:00:00	SPY	ETF	147.01	148.31	147.01	148.2	43791500.0
2007-11-13 16:00:00	SPY	ETF	148.19	148.23	145.22	148.0	3677900.0
2007-11-13 17:00:00	SPY	ETF	148.0	148.02	147.78	147.81	302100.0
2007-11-13 18:00:00	SPY	ETF	147.83	147.93	147.8	147.84	52400.0
2007-11-13 19:00:00	SPY	ETF	147.88	147.99	147.83	147.96	25500.0
2007-11-13 20:00:00	SPY	ETF	147.96	147.96	147.96	147.96	100.0
2007-11-13 04:00:00	QQQ	ETF	48.72	48.72	48.72	48.72	2000.0
2007-11-13 06:00:00	QQQ	ETF	48.93	49.05	48.9	48.91	73800.0
2007-11-13 07:00:00	QQQ	ETF	48.94	49.25	48.9	49.23	2705558.0
2007-11-13 08:00:00	QQQ	ETF	49.23	49.55	48.9	49.52	7669026.0
2007-11-13 09:00:00	QQQ	ETF	49.5	49.67	49.35	49.53	34189492.0
2007-11-13 10:00:00	QQQ	ETF	49.54	49.91	49.5	49.835	34857631.0
2007-11-13 11:00:00	QQQ	ETF	49.85	50.18	49.7	49.9715	32234519.0
2007-11-13 12:00:00	QQQ	ETF	49.98	50.12	49.68	49.75	31679048.0
2007-11-13 13:00:00	QQQ	ETF	49.7499	50.21	49.71	50.11	24697587.0
2007-11-13 14:00:00	QQQ	ETF	50.111	50.31	50.02	50.2781	19638243.0
2007-11-13 15:00:00	QQQ	ETF	50.28	50.79	50.28	50.79	64351972.0
2007-11-13 16:00:00	QQQ	ETF	50.79	50.7979	50.3805	50.64	7837631.0
2007-11-13 17:00:00	QQQ	ETF	50.64	50.7401	50.58	50.58	1047184.0
2007-11-13 18:00:00	QQQ	ETF	50.59	50.62	50.55	50.55	34181.0
2007-11-13 19:00:00	QQQ	ETF	50.57	50.74	50.55	50.62	327057.0
2007-11-13 06:00:00	IWM	ETF	76.91	76.91	76.91	76.91	1900.0
2007-11-13 07:00:00	IWM	ETF	76.83	77.02	76.79	76.95	81200.0
2007-11-13 08:00:00	IWM	ETF	77.03	77.17	77.0	77.08	595200.0
2007-11-13 09:00:00	IWM	ETF	77.13	77.64	77.1	77.34	9677611.0
2007-11-13 10:00:00	IWM	ETF	77.34	77.59	77.23	77.44	13849166.0
2007-11-13 11:00:00	IWM	ETF	77.44	77.78	77.3	77.45	11565140.0
2007-11-13 12:00:00	IWM	ETF	77.46	77.58	77.31	77.4	6696212.0
2007-11-13 13:00:00	IWM	ETF	77.42	77.95	77.33	77.84	12423420.0
2007-11-13 14:00:00	IWM	ETF	77.83	78.1	77.76	78.03	9974880.0
2007-11-13 15:00:00	IWM	ETF	78.03	78.74	78.03	78.41	27949805.0
2007-11-13 16:00:00	IWM	ETF	78.41	78.6	78.17	78.56	12341700.0
2007-11-13 17:00:00	IWM	ETF	78.45	78.45	78.3	78.32	66100.0
2007-11-13 18:00:00	IWM	ETF	78.33	78.33	78.33	78.33	1000.0
2007-11-13 19:00:00	IWM	ETF	78.3	78.38	78.3	78.33	2800.0
2007-11-13 07:00:00	DIA	ETF	130.6	130.81	130.6	130.81	6600.0
2007-11-13 08:00:00	DIA	ETF	130.78	130.83	130.6	130.75	13900.0
2007-11-13 09:00:00	DIA	ETF	130.75	131.35	130.75	131.14	2453254.0
2007-11-13 10:00:00	DIA	ETF	131.16	131.63	131.09	131.44	2391751.0
2007-11-13 11:00:00	DIA	ETF	131.44	131.96	131.37	131.82	2194788.0

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

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