PREVIEW / etf_1hour / 2007-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-28.parquet
  size:    94 KB
  rows:    3,138

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-12-28 06:00:00	SPY	ETF	148.18	148.21	148.18	148.21	30000.0
2007-12-28 07:00:00	SPY	ETF	148.55	148.98	148.5	148.85	401300.0
2007-12-28 08:00:00	SPY	ETF	148.83	148.9	147.76	148.58	4173400.0
2007-12-28 09:00:00	SPY	ETF	148.59	148.61	148.26	148.36	14283068.0
2007-12-28 10:00:00	SPY	ETF	148.35	148.35	147.47	147.66	20020823.0
2007-12-28 11:00:00	SPY	ETF	147.66	148.02	147.53	147.61	8813696.0
2007-12-28 12:00:00	SPY	ETF	147.61	147.67	146.91	147.0	13167686.0
2007-12-28 13:00:00	SPY	ETF	147.01	147.52	146.9	147.45	15706065.0
2007-12-28 14:00:00	SPY	ETF	147.46	147.74	147.3	147.5	12151755.0
2007-12-28 15:00:00	SPY	ETF	147.5	147.75	147.33	147.55	19053281.0
2007-12-28 16:00:00	SPY	ETF	147.6	147.68	147.0447	147.1	6366000.0
2007-12-28 17:00:00	SPY	ETF	147.08	147.2	147.07	147.1	20100.0
2007-12-28 18:00:00	SPY	ETF	147.1	147.15	147.1	147.11	31300.0
2007-12-28 19:00:00	SPY	ETF	147.14	147.14	147.06	147.09	8800.0
2007-12-28 05:00:00	QQQ	ETF	51.97	51.97	51.97	51.97	3000.0
2007-12-28 06:00:00	QQQ	ETF	51.97	52.02	51.97	52.02	16200.0
2007-12-28 07:00:00	QQQ	ETF	52.07	52.21	52.0	52.18	210802.0
2007-12-28 08:00:00	QQQ	ETF	52.18	52.21	52.08	52.1	1306993.0
2007-12-28 09:00:00	QQQ	ETF	52.1	52.16	51.97	52.04	11166270.0
2007-12-28 10:00:00	QQQ	ETF	52.03	52.1	51.75	51.86	9483500.0
2007-12-28 11:00:00	QQQ	ETF	51.87	51.95	51.78	51.84	4289859.0
2007-12-28 12:00:00	QQQ	ETF	51.83	51.86	51.48	51.49	10238967.0
2007-12-28 13:00:00	QQQ	ETF	51.48	51.79	51.43	51.78	11251097.0
2007-12-28 14:00:00	QQQ	ETF	51.78	51.86	51.61	51.69	6492997.0
2007-12-28 15:00:00	QQQ	ETF	51.69	51.8	51.58	51.79	12296201.0
2007-12-28 16:00:00	QQQ	ETF	51.79	51.86	51.71	51.74	1071644.0
2007-12-28 17:00:00	QQQ	ETF	51.73	51.77	51.72	51.76	25181.0
2007-12-28 18:00:00	QQQ	ETF	51.75	51.75	51.74	51.74	1600.0
2007-12-28 19:00:00	QQQ	ETF	51.74	51.74	51.71	51.71	5548.0
2007-12-28 04:00:00	IWM	ETF	77.5	77.5	77.5	77.5	100.0
2007-12-28 07:00:00	IWM	ETF	77.87	78.09	77.87	78.0	61100.0
2007-12-28 08:00:00	IWM	ETF	77.97	78.04	77.88	77.89	766700.0
2007-12-28 09:00:00	IWM	ETF	77.9	78.01	77.69	77.77	7054876.0
2007-12-28 10:00:00	IWM	ETF	77.76	77.76	77.18	77.45	7910563.0
2007-12-28 11:00:00	IWM	ETF	77.45	77.56	77.2	77.24	5021820.0
2007-12-28 12:00:00	IWM	ETF	77.24	77.42	76.74	76.76	6127147.0
2007-12-28 13:00:00	IWM	ETF	76.75	77.01	76.68	77.01	6010539.0
2007-12-28 14:00:00	IWM	ETF	77.01	77.17	76.81	76.94	4421994.0
2007-12-28 15:00:00	IWM	ETF	76.93	77.4	76.72	76.78	8670681.0
2007-12-28 16:00:00	IWM	ETF	76.78	77.23	76.0	76.56	2579710.0
2007-12-28 17:00:00	IWM	ETF	76.6	76.6	76.6	76.6	300.0
2007-12-28 18:00:00	IWM	ETF	76.72	76.72	76.56	76.56	16100.0
2007-12-28 19:00:00	IWM	ETF	76.72	76.72	76.72	76.72	700.0
2007-12-28 07:00:00	DIA	ETF	134.23	134.57	134.23	134.51	54700.0
2007-12-28 08:00:00	DIA	ETF	134.47	134.51	134.28	134.28	17300.0
2007-12-28 09:00:00	DIA	ETF	134.19	134.4	134.1	134.17	1025096.0
2007-12-28 10:00:00	DIA	ETF	134.16	134.16	133.47	133.57	1210188.0
2007-12-28 11:00:00	DIA	ETF	133.57	133.87	133.44	133.5	770654.0
2007-12-28 12:00:00	DIA	ETF	133.5	133.58	132.88	132.89	818072.0
2007-12-28 13:00:00	DIA	ETF	132.91	133.33	132.82	133.31	746487.0

> showing 50 of 3,138 rows — these rows as CSV

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