PREVIEW / etf_1hour / 2007-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-20.parquet
  size:    67 KB
  rows:    2,120

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-20 06:00:00	SPY	ETF	140.0	140.0	140.0	140.0	5000.0
2007-03-20 07:00:00	SPY	ETF	140.01	140.04	139.93	139.99	163800.0
2007-03-20 08:00:00	SPY	ETF	139.97	140.39	139.97	140.13	2977800.0
2007-03-20 09:00:00	SPY	ETF	140.11	140.32	139.96	140.05	7985242.0
2007-03-20 10:00:00	SPY	ETF	140.05	140.42	139.97	140.3599	11349400.0
2007-03-20 11:00:00	SPY	ETF	140.36	140.59	140.34	140.58	8140158.0
2007-03-20 12:00:00	SPY	ETF	140.59	141.04	140.56	140.8	14121425.0
2007-03-20 13:00:00	SPY	ETF	140.8	141.01	140.5	140.59	12383057.0
2007-03-20 14:00:00	SPY	ETF	140.59	140.74	140.49	140.63	6718638.0
2007-03-20 15:00:00	SPY	ETF	140.63	141.04	140.5	140.93	13084881.0
2007-03-20 16:00:00	SPY	ETF	140.94	141.07	140.9	140.95	1500500.0
2007-03-20 17:00:00	SPY	ETF	140.95	140.97	140.8	140.95	946400.0
2007-03-20 18:00:00	SPY	ETF	140.88	140.91	140.86	140.89	710200.0
2007-03-20 19:00:00	SPY	ETF	140.87	140.9	140.85	140.9	2800.0
2007-03-20 07:00:00	QQQ	ETF	43.25	43.25	43.25	43.25	50000.0
2007-03-20 08:00:00	QQQ	ETF	43.24	43.42	43.21	43.31	1958953.0
2007-03-20 09:00:00	QQQ	ETF	43.31	43.34	43.21	43.23	7909053.0
2007-03-20 10:00:00	QQQ	ETF	43.24	43.41	43.23	43.36	8110800.0
2007-03-20 11:00:00	QQQ	ETF	43.36	43.46	43.34	43.43	8013800.0
2007-03-20 12:00:00	QQQ	ETF	43.43	43.53	43.41	43.52	7879500.0
2007-03-20 13:00:00	QQQ	ETF	43.51	43.59	43.32	43.37	12643900.0
2007-03-20 14:00:00	QQQ	ETF	43.36	43.41	43.32	43.38	8284200.0
2007-03-20 15:00:00	QQQ	ETF	43.39	43.53	43.38	43.45	15232600.0
2007-03-20 16:00:00	QQQ	ETF	43.45	43.63	43.44	43.56	7499764.0
2007-03-20 17:00:00	QQQ	ETF	43.56	43.57	43.52	43.56	279828.0
2007-03-20 18:00:00	QQQ	ETF	43.55	43.57	43.54	43.57	1268899.0
2007-03-20 19:00:00	QQQ	ETF	43.55	43.57	43.54	43.55	21352.0
2007-03-20 08:00:00	IWM	ETF	78.06	78.36	78.06	78.21	108800.0
2007-03-20 09:00:00	IWM	ETF	78.2	78.27	77.96	78.06	3333000.0
2007-03-20 10:00:00	IWM	ETF	78.06	78.54	78.0	78.48	7650400.0
2007-03-20 11:00:00	IWM	ETF	78.48	78.62	78.39	78.62	6613800.0
2007-03-20 12:00:00	IWM	ETF	78.63	78.8	78.61	78.68	8461200.0
2007-03-20 13:00:00	IWM	ETF	78.68	78.79	78.4	78.52	4984833.0
2007-03-20 14:00:00	IWM	ETF	78.53	78.69	78.51	78.6	4440100.0
2007-03-20 15:00:00	IWM	ETF	78.59	78.84	78.58	78.84	6927982.0
2007-03-20 16:00:00	IWM	ETF	78.86	78.9	78.81	78.87	938100.0
2007-03-20 17:00:00	IWM	ETF	78.85	78.86	78.77	78.82	60000.0
2007-03-20 18:00:00	IWM	ETF	78.75	78.75	78.75	78.75	137500.0
2007-03-20 19:00:00	IWM	ETF	78.82	78.82	78.82	78.82	400.0
2007-03-20 08:00:00	DIA	ETF	122.1	122.32	122.1	122.2	38000.0
2007-03-20 09:00:00	DIA	ETF	122.22	122.3	122.01	122.07	565700.0
2007-03-20 10:00:00	DIA	ETF	122.07	122.35	122.03	122.33	912400.0
2007-03-20 11:00:00	DIA	ETF	122.33	122.48	122.2815	122.47	757200.0
2007-03-20 12:00:00	DIA	ETF	122.47	122.71	122.46	122.61	2186750.0
2007-03-20 13:00:00	DIA	ETF	122.6	122.77	122.46	122.56	1184800.0
2007-03-20 14:00:00	DIA	ETF	122.56	122.65	122.49	122.55	559700.0
2007-03-20 15:00:00	DIA	ETF	122.56	122.81	122.56	122.75	1024100.0
2007-03-20 16:00:00	DIA	ETF	122.76	122.83	122.75	122.77	119200.0
2007-03-20 18:00:00	DIA	ETF	122.77	122.77	122.77	122.77	149900.0
2007-03-20 19:00:00	DIA	ETF	122.78	122.8	122.78	122.8	1400.0

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

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