PREVIEW / etf_1hour / 2006-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-10.parquet
  size:    39 KB
  rows:    1,217

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-03-10 05:00:00	SPY	ETF	126.99	126.99	126.99	126.99	100.0
2006-03-10 07:00:00	SPY	ETF	127.54	127.67	127.51	127.67	140900.0
2006-03-10 08:00:00	SPY	ETF	127.63	127.98	127.45	127.83	3230200.0
2006-03-10 09:00:00	SPY	ETF	127.84	127.98	127.44	127.83	9481200.0
2006-03-10 10:00:00	SPY	ETF	127.82	128.62	127.61	128.57	12599700.0
2006-03-10 11:00:00	SPY	ETF	128.56	128.69	128.33	128.59	6166000.0
2006-03-10 12:00:00	SPY	ETF	128.6	128.84	128.45	128.55	5154200.0
2006-03-10 13:00:00	SPY	ETF	128.55	128.64	128.38	128.55	3733200.0
2006-03-10 14:00:00	SPY	ETF	128.56	128.68	128.11	128.14	6335100.0
2006-03-10 15:00:00	SPY	ETF	128.16	128.59	128.01	128.53	9261200.0
2006-03-10 16:00:00	SPY	ETF	128.53	128.59	128.45	128.5	2937700.0
2006-03-10 17:00:00	SPY	ETF	128.54	128.55	128.51	128.52	3100.0
2006-03-10 18:00:00	SPY	ETF	128.54	128.54	128.43	128.43	700.0
2006-03-10 19:00:00	SPY	ETF	128.44	128.5	128.43	128.49	2300.0
2006-03-10 09:00:00	QQQ	ETF	40.49	40.5	40.2	40.34	12769600.0
2006-03-10 10:00:00	QQQ	ETF	40.35	40.76	40.19	40.73	25725400.0
2006-03-10 11:00:00	QQQ	ETF	40.72	40.72	40.61	40.66	9109100.0
2006-03-10 12:00:00	QQQ	ETF	40.66	40.79	40.64	40.7	10289800.0
2006-03-10 13:00:00	QQQ	ETF	40.7	40.73	40.6	40.67	5931800.0
2006-03-10 14:00:00	QQQ	ETF	40.68	40.75	40.46	40.47	8870200.0
2006-03-10 15:00:00	QQQ	ETF	40.47	40.66	40.39	40.54	14666200.0
2006-03-10 08:00:00	IWM	ETF	71.31	71.53	71.27	71.42	197800.0
2006-03-10 09:00:00	IWM	ETF	71.5	71.55	70.98	71.44	5772000.0
2006-03-10 10:00:00	IWM	ETF	71.45	72.16	71.34	72.12	8343200.0
2006-03-10 11:00:00	IWM	ETF	72.11	72.12	71.93	72.04	2894100.0
2006-03-10 12:00:00	IWM	ETF	72.05	72.35	72.04	72.13	3045000.0
2006-03-10 13:00:00	IWM	ETF	72.14	72.24	71.4295	72.1	3672000.0
2006-03-10 14:00:00	IWM	ETF	72.11	72.18	71.4295	71.84	7905300.0
2006-03-10 15:00:00	IWM	ETF	71.84	72.26	71.75	72.25	7133500.0
2006-03-10 16:00:00	IWM	ETF	72.25	72.35	72.1	72.25	319600.0
2006-03-10 17:00:00	IWM	ETF	72.0	72.0	72.0	72.0	200.0
2006-03-10 18:00:00	IWM	ETF	72.0	72.0	72.0	72.0	100.0
2006-03-10 07:00:00	DIA	ETF	109.74	109.82	109.74	109.79	300.0
2006-03-10 08:00:00	DIA	ETF	109.81	110.1	109.74	109.98	19400.0
2006-03-10 09:00:00	DIA	ETF	110.05	110.3	109.87	110.21	866100.0
2006-03-10 10:00:00	DIA	ETF	110.21	110.85	110.06	110.8099	2200200.0
2006-03-10 11:00:00	DIA	ETF	110.78	110.99	110.59	110.9	1995500.0
2006-03-10 12:00:00	DIA	ETF	110.91	111.04	110.68	110.75	739700.0
2006-03-10 13:00:00	DIA	ETF	110.75	110.87	110.56	110.72	625700.0
2006-03-10 14:00:00	DIA	ETF	110.73	110.86	110.46	110.47	765500.0
2006-03-10 15:00:00	DIA	ETF	110.46	110.84	110.38	110.78	1038600.0
2006-03-10 16:00:00	DIA	ETF	110.78	110.89	110.74	110.87	39300.0
2006-03-10 17:00:00	DIA	ETF	110.9	110.91	110.9	110.91	700.0
2006-03-10 08:00:00	GLD	ETF	53.9	53.96	53.44	53.65	319000.0
2006-03-10 09:00:00	GLD	ETF	53.6	53.61	53.14	53.32	1376500.0
2006-03-10 10:00:00	GLD	ETF	53.3	53.7576	53.24	53.68	1873800.0
2006-03-10 11:00:00	GLD	ETF	53.68	53.89	53.59	53.68	1386600.0
2006-03-10 12:00:00	GLD	ETF	53.67	53.82	53.44	53.78	493000.0
2006-03-10 13:00:00	GLD	ETF	53.78	53.88	53.65	53.79	399200.0
2006-03-10 14:00:00	GLD	ETF	53.78	53.96	53.77	53.8801	262800.0

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

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