PREVIEW / etf_1hour / 2007-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-20.parquet
  size:    81 KB
  rows:    2,673

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-20 04:00:00	SPY	ETF	153.49	153.49	153.49	153.49	400.0
2007-06-20 06:00:00	SPY	ETF	153.62	153.63	153.59	153.63	26600.0
2007-06-20 07:00:00	SPY	ETF	153.57	153.65	153.51	153.65	294600.0
2007-06-20 08:00:00	SPY	ETF	153.64	153.8	153.62	153.72	1652000.0
2007-06-20 09:00:00	SPY	ETF	153.71	153.72	152.96	152.98	17813225.0
2007-06-20 10:00:00	SPY	ETF	152.98	153.43	152.64	153.27	25460136.0
2007-06-20 11:00:00	SPY	ETF	153.27	153.58	152.7	152.85	18250045.0
2007-06-20 12:00:00	SPY	ETF	152.85	152.97	152.58	152.84	15642040.0
2007-06-20 13:00:00	SPY	ETF	152.84	153.1375	152.19	152.42	30848155.0
2007-06-20 14:00:00	SPY	ETF	152.43	152.71	151.95	152.2	28625731.0
2007-06-20 15:00:00	SPY	ETF	152.21	152.58	150.96	151.0	33366108.0
2007-06-20 16:00:00	SPY	ETF	151.0	152.75	150.99	151.15	2954900.0
2007-06-20 17:00:00	SPY	ETF	151.15	151.2	151.09	151.14	162700.0
2007-06-20 18:00:00	SPY	ETF	151.14	151.25	151.14	151.19	66200.0
2007-06-20 19:00:00	SPY	ETF	151.2	151.24	151.18	151.22	7300.0
2007-06-20 06:00:00	QQQ	ETF	47.88	47.88	47.88	47.88	300.0
2007-06-20 07:00:00	QQQ	ETF	47.88	47.91	47.86	47.9	164516.0
2007-06-20 08:00:00	QQQ	ETF	47.9	47.96	47.9	47.93	1313382.0
2007-06-20 09:00:00	QQQ	ETF	47.93	47.93	47.61	47.64	13237896.0
2007-06-20 10:00:00	QQQ	ETF	47.64	47.92	47.57	47.88	35323377.0
2007-06-20 11:00:00	QQQ	ETF	47.88	47.89	47.71	47.76	17141940.0
2007-06-20 12:00:00	QQQ	ETF	47.761	47.85	47.69	47.8	8305298.0
2007-06-20 13:00:00	QQQ	ETF	47.79	47.8	47.51	47.65	19646605.0
2007-06-20 14:00:00	QQQ	ETF	47.65	47.74	47.49	47.58	20781869.0
2007-06-20 15:00:00	QQQ	ETF	47.584	47.584	47.24	47.26	31596786.0
2007-06-20 16:00:00	QQQ	ETF	47.27	47.69	47.25	47.31	8704689.0
2007-06-20 17:00:00	QQQ	ETF	47.3	47.35	47.28	47.33	510447.0
2007-06-20 18:00:00	QQQ	ETF	47.34	47.34	47.32	47.33	2950.0
2007-06-20 19:00:00	QQQ	ETF	47.33	47.33	47.31	47.31	29700.0
2007-06-20 07:00:00	IWM	ETF	84.62	84.65	84.58	84.65	27200.0
2007-06-20 08:00:00	IWM	ETF	84.65	84.77	84.64	84.67	578600.0
2007-06-20 09:00:00	IWM	ETF	84.67	84.67	84.25	84.26	7954617.0
2007-06-20 10:00:00	IWM	ETF	84.26	84.5	84.04	84.49	11541445.0
2007-06-20 11:00:00	IWM	ETF	84.49	84.49	83.89	83.97	10406325.0
2007-06-20 12:00:00	IWM	ETF	83.98	84.11	83.81	84.07	5333700.0
2007-06-20 13:00:00	IWM	ETF	84.07	84.08	83.65	83.89	9709445.0
2007-06-20 14:00:00	IWM	ETF	83.89	84.03	83.59	83.8	9557017.0
2007-06-20 15:00:00	IWM	ETF	83.8	83.81	83.05	83.09	21398755.0
2007-06-20 16:00:00	IWM	ETF	83.09	83.15	82.91	83.05	1510200.0
2007-06-20 17:00:00	IWM	ETF	82.98	82.98	82.98	82.98	100.0
2007-06-20 18:00:00	IWM	ETF	83.0	83.0	82.95	82.95	25400.0
2007-06-20 07:00:00	DIA	ETF	136.68	136.7	136.66	136.66	3300.0
2007-06-20 08:00:00	DIA	ETF	136.67	136.85	136.66	136.75	21600.0
2007-06-20 09:00:00	DIA	ETF	136.75	136.75	136.15	136.18	1276500.0
2007-06-20 10:00:00	DIA	ETF	136.18	136.58	135.92	136.47	2498050.0
2007-06-20 11:00:00	DIA	ETF	136.47	136.49	136.13	136.23	1872500.0
2007-06-20 12:00:00	DIA	ETF	136.24	136.35	136.05	136.23	1300000.0
2007-06-20 13:00:00	DIA	ETF	136.22	136.24	135.72	135.89	2351701.0
2007-06-20 14:00:00	DIA	ETF	135.89	136.12	135.5	135.73	2805617.0
2007-06-20 15:00:00	DIA	ETF	135.73	135.75	134.7	134.71	4436400.0

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

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