PREVIEW / etf_1hour / 2006-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-23.parquet
  size:    55 KB
  rows:    1,764

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
2006-10-23 07:00:00	SPY	ETF	136.77	136.81	136.75	136.77	39500.0
2006-10-23 08:00:00	SPY	ETF	136.77	136.85	136.43	136.57	654500.0
2006-10-23 09:00:00	SPY	ETF	136.57	136.92	136.39	136.87	8443100.0
2006-10-23 10:00:00	SPY	ETF	136.88	137.57	136.85	137.41	13737100.0
2006-10-23 11:00:00	SPY	ETF	137.42	137.75	137.42	137.6	10336300.0
2006-10-23 12:00:00	SPY	ETF	137.59	137.8	137.57	137.61	5193800.0
2006-10-23 13:00:00	SPY	ETF	137.61	137.74	137.44	137.55	5814100.0
2006-10-23 14:00:00	SPY	ETF	137.56	137.57	136.8983	137.54	7699000.0
2006-10-23 15:00:00	SPY	ETF	137.53	137.77	137.52	137.68	7781700.0
2006-10-23 16:00:00	SPY	ETF	137.66	137.67	137.27	137.4	999000.0
2006-10-23 17:00:00	SPY	ETF	137.4	137.43	137.35	137.43	125200.0
2006-10-23 18:00:00	SPY	ETF	137.4	137.4	137.32	137.32	14100.0
2006-10-23 19:00:00	SPY	ETF	137.33	137.34	137.3	137.3	3400.0
2006-10-23 09:00:00	QQQ	ETF	41.92	42.05	41.82	42.03	10719300.0
2006-10-23 10:00:00	QQQ	ETF	42.02	42.55	42.02	42.46	43482500.0
2006-10-23 11:00:00	QQQ	ETF	42.46	42.58	42.42	42.47	15769200.0
2006-10-23 12:00:00	QQQ	ETF	42.47	42.56	42.42	42.44	9415500.0
2006-10-23 13:00:00	QQQ	ETF	42.44	42.5	42.35	42.41	9812500.0
2006-10-23 14:00:00	QQQ	ETF	42.4	42.42	42.24	42.38	13290400.0
2006-10-23 15:00:00	QQQ	ETF	42.38	42.46	42.33	42.43	15883500.0
2006-10-23 08:00:00	IWM	ETF	76.0	76.25	75.26	75.36	29500.0
2006-10-23 09:00:00	IWM	ETF	75.36	75.75	75.09	75.71	3438800.0
2006-10-23 10:00:00	IWM	ETF	75.73	76.25	75.59	76.04	9662800.0
2006-10-23 11:00:00	IWM	ETF	76.05	76.28	75.89	75.98	4546300.0
2006-10-23 12:00:00	IWM	ETF	75.97	76.18	75.9	75.9	3441000.0
2006-10-23 13:00:00	IWM	ETF	75.88	76.0	75.65	75.75	2842500.0
2006-10-23 14:00:00	IWM	ETF	75.76	75.84	75.49	75.74	5098100.0
2006-10-23 15:00:00	IWM	ETF	75.74	75.94	75.74	75.87	5915500.0
2006-10-23 16:00:00	IWM	ETF	75.87	75.92	75.51	75.71	284300.0
2006-10-23 17:00:00	IWM	ETF	75.69	75.69	75.68	75.68	1100.0
2006-10-23 19:00:00	IWM	ETF	75.67	75.68	75.67	75.68	1000.0
2006-10-23 07:00:00	DIA	ETF	120.02	120.02	119.96	119.96	2100.0
2006-10-23 08:00:00	DIA	ETF	119.95	120.03	119.71	119.77	38100.0
2006-10-23 09:00:00	DIA	ETF	119.75	120.21	119.7	120.16	868800.0
2006-10-23 10:00:00	DIA	ETF	120.16	120.729	120.16	120.65	2027800.0
2006-10-23 11:00:00	DIA	ETF	120.65	120.9	120.65	120.87	1021700.0
2006-10-23 12:00:00	DIA	ETF	120.8601	121.13	120.84	120.99	1318700.0
2006-10-23 13:00:00	DIA	ETF	120.98	121.11	120.81	120.92	1203300.0
2006-10-23 14:00:00	DIA	ETF	120.92	120.99	120.69	120.94	1387500.0
2006-10-23 15:00:00	DIA	ETF	120.9301	121.1	120.9	121.04	1768100.0
2006-10-23 16:00:00	DIA	ETF	121.05	121.05	120.74	120.76	100300.0
2006-10-23 18:00:00	DIA	ETF	120.75	120.78	120.75	120.78	200.0
2006-10-23 07:00:00	GLD	ETF	58.3	58.3	58.23	58.23	1300.0
2006-10-23 08:00:00	GLD	ETF	58.19	58.21	57.98	58.15	50200.0
2006-10-23 09:00:00	GLD	ETF	58.03	58.06	57.79	57.93	626600.0
2006-10-23 10:00:00	GLD	ETF	57.92	58.19	57.86	58.06	801000.0
2006-10-23 11:00:00	GLD	ETF	58.07	58.12	57.88	58.02	308100.0
2006-10-23 12:00:00	GLD	ETF	58.01	58.09	57.89	58.02	341600.0
2006-10-23 13:00:00	GLD	ETF	58.01	58.05	57.52	57.66	721100.0
2006-10-23 14:00:00	GLD	ETF	57.65	57.75	57.59	57.72	233700.0

> showing 50 of 1,764 rows — these rows as CSV

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