PREVIEW / etf_1hour / 2007-03-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	140.82	140.82	140.82	140.82	100.0
2007-03-13 06:00:00	SPY	ETF	140.87	140.87	140.74	140.74	21200.0
2007-03-13 07:00:00	SPY	ETF	140.72	140.72	140.21	140.4	864600.0
2007-03-13 08:00:00	SPY	ETF	140.89	140.89	140.16	140.25	5649400.0
2007-03-13 09:00:00	SPY	ETF	140.21	140.58	139.99	140.44	12851400.0
2007-03-13 10:00:00	SPY	ETF	140.43	140.74	140.2	140.62	16394300.0
2007-03-13 11:00:00	SPY	ETF	140.62	140.77	140.32	140.38	11071500.0
2007-03-13 12:00:00	SPY	ETF	140.38	140.48	139.36	139.55	31092700.0
2007-03-13 13:00:00	SPY	ETF	139.55	139.71	138.9	139.27	20688400.0
2007-03-13 14:00:00	SPY	ETF	139.26	139.34	138.39	138.63	24282500.0
2007-03-13 15:00:00	SPY	ETF	138.62	139.0	138.11	138.15	38981900.0
2007-03-13 16:00:00	SPY	ETF	138.16	140.4	138.04	138.33	6059500.0
2007-03-13 17:00:00	SPY	ETF	138.3	138.4	138.24	138.3	1277200.0
2007-03-13 18:00:00	SPY	ETF	138.3	138.38	138.22	138.22	5197300.0
2007-03-13 19:00:00	SPY	ETF	138.25	138.27	138.11	138.14	521000.0
2007-03-13 06:00:00	QQQ	ETF	43.17	43.17	43.17	43.17	100.0
2007-03-13 07:00:00	QQQ	ETF	43.12	43.12	42.96	43.0	878579.0
2007-03-13 08:00:00	QQQ	ETF	43.02	43.08	42.87	42.95	3868223.0
2007-03-13 09:00:00	QQQ	ETF	42.96	43.24	42.93	43.13	20734401.0
2007-03-13 10:00:00	QQQ	ETF	43.13	43.2	43.0	43.15	16557800.0
2007-03-13 11:00:00	QQQ	ETF	43.15	43.2	42.98	43.03	10050100.0
2007-03-13 12:00:00	QQQ	ETF	43.03	43.07	42.6	42.71	27448500.0
2007-03-13 13:00:00	QQQ	ETF	42.71	42.8	42.61	42.72	18390600.0
2007-03-13 14:00:00	QQQ	ETF	42.71	42.74	42.47	42.56	24576300.0
2007-03-13 15:00:00	QQQ	ETF	42.56	42.7	42.37	42.37	38153900.0
2007-03-13 16:00:00	QQQ	ETF	42.36	42.6401	42.27	42.37	5921610.0
2007-03-13 17:00:00	QQQ	ETF	42.37	42.4	42.36	42.36	155877.0
2007-03-13 18:00:00	QQQ	ETF	42.37	42.39	42.37	42.38	2223694.0
2007-03-13 19:00:00	QQQ	ETF	42.38	42.39	42.33	42.34	41964.0
2007-03-13 07:00:00	IWM	ETF	77.95	77.95	77.8	77.87	134600.0
2007-03-13 08:00:00	IWM	ETF	77.92	78.19	77.8	77.88	681700.0
2007-03-13 09:00:00	IWM	ETF	77.87	77.9101	77.65	77.78	8633700.0
2007-03-13 10:00:00	IWM	ETF	77.78	78.06	77.63	77.95	6817500.0
2007-03-13 11:00:00	IWM	ETF	77.95	77.98	77.56	77.68	5872800.0
2007-03-13 12:00:00	IWM	ETF	77.67	77.75	76.95	77.07	21163100.0
2007-03-13 13:00:00	IWM	ETF	77.07	77.16	76.69	76.89	14325100.0
2007-03-13 14:00:00	IWM	ETF	76.9	77.89	76.44	76.68	13627900.0
2007-03-13 15:00:00	IWM	ETF	76.68	76.86	76.26	76.39	19184700.0
2007-03-13 16:00:00	IWM	ETF	76.39	76.52	76.34	76.41	2322400.0
2007-03-13 17:00:00	IWM	ETF	76.42	76.45	76.38	76.38	9100.0
2007-03-13 18:00:00	IWM	ETF	76.4	76.4	76.34	76.34	233200.0
2007-03-13 19:00:00	IWM	ETF	76.39	76.39	76.31	76.32	31700.0
2007-03-13 07:00:00	DIA	ETF	122.82	122.82	122.68	122.7	4600.0
2007-03-13 08:00:00	DIA	ETF	122.73	122.95	122.51	122.59	55600.0
2007-03-13 09:00:00	DIA	ETF	122.5	122.87	122.33	122.76	939600.0
2007-03-13 10:00:00	DIA	ETF	122.76	122.9	122.5	122.82	922900.0
2007-03-13 11:00:00	DIA	ETF	122.83	122.99	122.52	122.65	1156500.0
2007-03-13 12:00:00	DIA	ETF	122.65	122.73	121.89	122.06	1630900.0
2007-03-13 13:00:00	DIA	ETF	122.06	122.2	121.62	121.83	1777400.0
2007-03-13 14:00:00	DIA	ETF	121.82	121.86	121.17	121.32	3654000.0

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

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