PREVIEW / etf_1hour / 2007-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-14.parquet
  size:    71 KB
  rows:    2,183

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-03-14 04:00:00	SPY	ETF	138.27	138.27	138.27	138.27	100.0
2007-03-14 05:00:00	SPY	ETF	138.21	138.34	138.2	138.2	6600.0
2007-03-14 06:00:00	SPY	ETF	138.1	138.21	137.95	138.04	132700.0
2007-03-14 07:00:00	SPY	ETF	138.09	138.37	137.76	138.02	908400.0
2007-03-14 08:00:00	SPY	ETF	138.02	138.36	137.78	138.15	3915500.0
2007-03-14 09:00:00	SPY	ETF	138.14	138.87	138.11	138.38	24732100.0
2007-03-14 10:00:00	SPY	ETF	138.38	138.88	137.01	138.46	30889300.0
2007-03-14 11:00:00	SPY	ETF	138.46	138.58	137.94	138.1	13869300.0
2007-03-14 12:00:00	SPY	ETF	138.1	138.11	136.75	136.97	51361600.0
2007-03-14 13:00:00	SPY	ETF	136.97	138.87	136.91	138.0	39876100.0
2007-03-14 14:00:00	SPY	ETF	138.0	139.17	137.86	138.71	29241800.0
2007-03-14 15:00:00	SPY	ETF	138.7	139.24	138.58	139.14	28040900.0
2007-03-14 16:00:00	SPY	ETF	139.14	139.38	139.0185	139.37	2771000.0
2007-03-14 17:00:00	SPY	ETF	139.38	139.59	139.36	139.57	171900.0
2007-03-14 18:00:00	SPY	ETF	139.55	139.58	139.5	139.55	2458300.0
2007-03-14 19:00:00	SPY	ETF	139.52	139.55	139.45	139.5	26300.0
2007-03-14 07:00:00	QQQ	ETF	42.28	42.41	42.2	42.32	436331.0
2007-03-14 08:00:00	QQQ	ETF	42.3	42.37	42.25	42.33	1410733.0
2007-03-14 09:00:00	QQQ	ETF	42.32	42.56	42.31	42.45	23004407.0
2007-03-14 10:00:00	QQQ	ETF	42.46	42.65	42.26	42.51	26401300.0
2007-03-14 11:00:00	QQQ	ETF	42.52	42.55	42.34	42.4	13809000.0
2007-03-14 12:00:00	QQQ	ETF	42.4	42.4	42.1	42.21	28203500.0
2007-03-14 13:00:00	QQQ	ETF	42.21	42.66	42.19	42.44	42488400.0
2007-03-14 14:00:00	QQQ	ETF	42.44	42.87	42.36	42.72	26352800.0
2007-03-14 15:00:00	QQQ	ETF	42.72	42.89	42.7	42.89	23715500.0
2007-03-14 16:00:00	QQQ	ETF	42.9	43.03	42.89	43.02	4018885.0
2007-03-14 17:00:00	QQQ	ETF	43.02	43.11	43.0	43.1	162751.0
2007-03-14 18:00:00	QQQ	ETF	43.09	43.11	43.08	43.1	370130.0
2007-03-14 19:00:00	QQQ	ETF	43.1	43.12	43.1	43.11	53604.0
2007-03-14 07:00:00	IWM	ETF	75.5	77.35	75.5	76.0	69100.0
2007-03-14 08:00:00	IWM	ETF	76.22	76.49	76.0	76.26	620800.0
2007-03-14 09:00:00	IWM	ETF	76.27	76.87	76.0999	76.21	18598500.0
2007-03-14 10:00:00	IWM	ETF	76.22	76.71	75.89	76.61	21514200.0
2007-03-14 11:00:00	IWM	ETF	76.61	76.67	76.24	76.3	6939000.0
2007-03-14 12:00:00	IWM	ETF	76.3	76.4	75.53	75.75	19010452.0
2007-03-14 13:00:00	IWM	ETF	75.75	76.63	75.71	76.26	19518639.0
2007-03-14 14:00:00	IWM	ETF	76.26	77.04	76.15	76.9115	19149700.0
2007-03-14 15:00:00	IWM	ETF	76.91	77.24	76.81	77.11	20623000.0
2007-03-14 16:00:00	IWM	ETF	77.1	78.0	77.07	77.3	875000.0
2007-03-14 17:00:00	IWM	ETF	77.3	77.48	76.993	77.48	190800.0
2007-03-14 18:00:00	IWM	ETF	77.44	77.47	77.36	77.36	285900.0
2007-03-14 19:00:00	IWM	ETF	77.43	77.48	77.43	77.45	44100.0
2007-03-14 07:00:00	DIA	ETF	120.96	120.96	120.52	120.55	3700.0
2007-03-14 08:00:00	DIA	ETF	120.62	120.92	120.6	120.81	39100.0
2007-03-14 09:00:00	DIA	ETF	120.81	121.35	120.58	120.99	2291400.0
2007-03-14 10:00:00	DIA	ETF	120.99	121.28	120.48	120.94	3203900.0
2007-03-14 11:00:00	DIA	ETF	120.94	121.05	120.55	120.64	1408200.0
2007-03-14 12:00:00	DIA	ETF	120.64	120.66	119.57	119.72	4035700.0
2007-03-14 13:00:00	DIA	ETF	119.72	121.02	119.5	120.59	4291500.0
2007-03-14 14:00:00	DIA	ETF	120.62	121.44	120.52	121.13	2783300.0

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

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