PREVIEW / etf_1hour / 2007-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-28.parquet
  size:    77 KB
  rows:    2,572

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-06-28 06:00:00	SPY	ETF	150.58	150.6	150.48	150.48	27500.0
2007-06-28 07:00:00	SPY	ETF	150.57	150.57	150.21	150.38	334200.0
2007-06-28 08:00:00	SPY	ETF	150.5	150.58	150.19	150.24	3891900.0
2007-06-28 09:00:00	SPY	ETF	150.25	150.58	150.22	150.54	12860601.0
2007-06-28 10:00:00	SPY	ETF	150.53	150.75	150.35	150.45	17279846.0
2007-06-28 11:00:00	SPY	ETF	150.45	150.84	150.34	150.8	15120278.0
2007-06-28 12:00:00	SPY	ETF	150.81	151.11	150.78	150.9	7487050.0
2007-06-28 13:00:00	SPY	ETF	150.91	151.18	149.67	151.05	10032943.0
2007-06-28 14:00:00	SPY	ETF	151.04	151.41	150.32	150.89	55125219.0
2007-06-28 15:00:00	SPY	ETF	150.89	151.11	150.4	150.4	26399571.0
2007-06-28 16:00:00	SPY	ETF	150.43	150.59	150.31	150.45	4523000.0
2007-06-28 17:00:00	SPY	ETF	150.41	150.42	150.38	150.42	5500.0
2007-06-28 18:00:00	SPY	ETF	150.41	150.41	150.37	150.4	591900.0
2007-06-28 19:00:00	SPY	ETF	150.39	150.4	150.38	150.38	3300.0
2007-06-28 04:00:00	QQQ	ETF	47.57	47.61	47.54	47.61	53050.0
2007-06-28 05:00:00	QQQ	ETF	47.63	47.63	47.63	47.63	100.0
2007-06-28 06:00:00	QQQ	ETF	47.56	47.56	47.56	47.56	500.0
2007-06-28 07:00:00	QQQ	ETF	47.6	47.6	47.47	47.52	194296.0
2007-06-28 08:00:00	QQQ	ETF	47.51	47.63	47.51	47.52	2729881.0
2007-06-28 09:00:00	QQQ	ETF	47.52	47.6	47.46	47.5901	14470768.0
2007-06-28 10:00:00	QQQ	ETF	47.61	47.67	47.56	47.58	16568213.0
2007-06-28 11:00:00	QQQ	ETF	47.57	47.66	47.51	47.65	7193156.0
2007-06-28 12:00:00	QQQ	ETF	47.65	47.7	47.63	47.63	6620050.0
2007-06-28 13:00:00	QQQ	ETF	47.635	47.71	47.59	47.6795	4905844.0
2007-06-28 14:00:00	QQQ	ETF	47.67	47.85	47.51	47.68	33980495.0
2007-06-28 15:00:00	QQQ	ETF	47.68	47.71	47.5	47.5	20579267.0
2007-06-28 16:00:00	QQQ	ETF	47.51	47.66	47.44	47.62	4854784.0
2007-06-28 17:00:00	QQQ	ETF	47.63	47.63	47.59	47.61	183196.0
2007-06-28 18:00:00	QQQ	ETF	47.59	47.59	47.58	47.59	2600.0
2007-06-28 19:00:00	QQQ	ETF	47.59	47.6	47.58	47.6	18000.0
2007-06-28 07:00:00	IWM	ETF	83.4	83.46	83.39	83.46	29500.0
2007-06-28 08:00:00	IWM	ETF	83.46	83.75	83.35	83.41	664400.0
2007-06-28 09:00:00	IWM	ETF	83.46	83.64	83.3	83.6	8514386.0
2007-06-28 10:00:00	IWM	ETF	83.59	83.81	83.5	83.54	11598565.0
2007-06-28 11:00:00	IWM	ETF	83.54	83.77	83.46	83.75	9183576.0
2007-06-28 12:00:00	IWM	ETF	83.76	83.91	83.57	83.76	7761438.0
2007-06-28 13:00:00	IWM	ETF	83.75	83.92	83.57	83.8	6886900.0
2007-06-28 14:00:00	IWM	ETF	83.81	84.19	83.4	83.63	22770970.0
2007-06-28 15:00:00	IWM	ETF	83.63	83.81	83.4	83.46	11233891.0
2007-06-28 16:00:00	IWM	ETF	83.46	83.49	83.37	83.44	1154100.0
2007-06-28 17:00:00	IWM	ETF	83.4	83.48	83.4	83.48	71000.0
2007-06-28 18:00:00	IWM	ETF	83.42	83.42	83.4	83.42	5700.0
2007-06-28 19:00:00	IWM	ETF	83.41	83.41	83.41	83.41	300.0
2007-06-28 07:00:00	DIA	ETF	134.2	134.2	134.01	134.01	200.0
2007-06-28 08:00:00	DIA	ETF	134.18	134.18	133.91	133.91	15700.0
2007-06-28 09:00:00	DIA	ETF	133.98	134.16	133.9	134.1	792000.0
2007-06-28 10:00:00	DIA	ETF	134.1	134.28	133.98	134.07	1837899.0
2007-06-28 11:00:00	DIA	ETF	134.08	134.33	134.02	134.29	928900.0
2007-06-28 12:00:00	DIA	ETF	134.3	134.44	134.26	134.37	842300.0
2007-06-28 13:00:00	DIA	ETF	134.37	134.53	134.18	134.44	546400.0

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

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