PREVIEW / etf_1hour / 2008-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-02.parquet
  size:    115 KB
  rows:    3,742

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
2008-12-02 04:00:00	SPY	ETF	82.69	83.0	82.54	83.0	6000.0
2008-12-02 05:00:00	SPY	ETF	83.0	83.59	83.0	83.31	9840.0
2008-12-02 06:00:00	SPY	ETF	83.29	84.01	83.29	84.01	195547.0
2008-12-02 07:00:00	SPY	ETF	84.0	84.12	83.32	83.61	1019179.0
2008-12-02 08:00:00	SPY	ETF	83.92	84.02	82.35	83.72	6074516.0
2008-12-02 09:00:00	SPY	ETF	83.73	83.75	82.23	82.6	40781299.0
2008-12-02 10:00:00	SPY	ETF	82.61	84.59	82.3	84.13	81819469.0
2008-12-02 11:00:00	SPY	ETF	84.13	84.83	83.67	84.64	44674351.0
2008-12-02 12:00:00	SPY	ETF	84.6325	85.24	84.55	84.848	34780921.0
2008-12-02 13:00:00	SPY	ETF	84.85	85.1	83.64	83.75	38211626.0
2008-12-02 14:00:00	SPY	ETF	83.75	83.92	82.29	83.7	76041099.0
2008-12-02 15:00:00	SPY	ETF	83.7	85.49	82.77	85.4	131029581.0
2008-12-02 16:00:00	SPY	ETF	85.31	85.61	82.038	85.34	11909765.0
2008-12-02 17:00:00	SPY	ETF	85.32	85.38	85.2	85.24	134127.0
2008-12-02 18:00:00	SPY	ETF	85.2	85.34	84.99	84.99	781238.0
2008-12-02 19:00:00	SPY	ETF	84.99	85.13	84.93	85.0	140105.0
2008-12-02 05:00:00	QQQ	ETF	27.28	27.41	27.28	27.41	1050.0
2008-12-02 06:00:00	QQQ	ETF	27.39	27.65	27.39	27.63	14940.0
2008-12-02 07:00:00	QQQ	ETF	27.66	27.67	27.39	27.46	548189.0
2008-12-02 08:00:00	QQQ	ETF	27.45	27.51	27.25	27.36	3359310.0
2008-12-02 09:00:00	QQQ	ETF	27.36	27.36	26.8404	27.05	20018203.0
2008-12-02 10:00:00	QQQ	ETF	27.0499	27.68	27.0	27.61	31607080.0
2008-12-02 11:00:00	QQQ	ETF	27.61	27.77	27.45	27.73	18273569.0
2008-12-02 12:00:00	QQQ	ETF	27.73	27.89	27.65	27.77	12701197.0
2008-12-02 13:00:00	QQQ	ETF	27.76	27.85	27.41	27.44	15181905.0
2008-12-02 14:00:00	QQQ	ETF	27.44	27.49	26.99	27.45	27305002.0
2008-12-02 15:00:00	QQQ	ETF	27.45	27.87	27.11	27.85	26343039.0
2008-12-02 16:00:00	QQQ	ETF	27.84	27.97	27.73	27.87	4700276.0
2008-12-02 17:00:00	QQQ	ETF	27.89	27.9	27.83	27.87	63532.0
2008-12-02 18:00:00	QQQ	ETF	27.86	27.86	27.78	27.8	30896.0
2008-12-02 19:00:00	QQQ	ETF	27.78	27.82	27.74	27.74	15932.0
2008-12-02 07:00:00	IWM	ETF	43.16	43.16	42.67	42.73	112700.0
2008-12-02 08:00:00	IWM	ETF	42.49	43.11	42.32	42.87	499233.0
2008-12-02 09:00:00	IWM	ETF	42.9	42.94	41.96	42.48	10230417.0
2008-12-02 10:00:00	IWM	ETF	42.48	43.3	42.35	43.15	16077962.0
2008-12-02 11:00:00	IWM	ETF	43.13	43.68	42.79	43.54	9578786.0
2008-12-02 12:00:00	IWM	ETF	43.54	44.01	43.43	43.76	7379851.0
2008-12-02 13:00:00	IWM	ETF	43.75	43.83	42.98	43.0	5577462.0
2008-12-02 14:00:00	IWM	ETF	42.99	43.44	42.32	43.42	9491287.0
2008-12-02 15:00:00	IWM	ETF	43.41	44.33	42.73	44.2	18692272.0
2008-12-02 16:00:00	IWM	ETF	44.21	44.46	42.55	44.33	4637531.0
2008-12-02 17:00:00	IWM	ETF	44.21	44.21	41.81	41.81	506900.0
2008-12-02 06:00:00	DIA	ETF	82.81	83.22	82.81	83.16	1100.0
2008-12-02 07:00:00	DIA	ETF	83.24	83.27	82.8	82.95	15502.0
2008-12-02 08:00:00	DIA	ETF	82.94	83.09	82.5	82.95	115500.0
2008-12-02 09:00:00	DIA	ETF	82.92	82.95	81.61	81.9	3349800.0
2008-12-02 10:00:00	DIA	ETF	81.91	83.75	81.78	83.39	4587463.0
2008-12-02 11:00:00	DIA	ETF	83.39	84.0	82.95	83.83	3532719.0
2008-12-02 12:00:00	DIA	ETF	83.84	84.27	83.65	83.89	2327030.0
2008-12-02 13:00:00	DIA	ETF	83.87	84.16	82.82	82.89	2667430.0

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

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