PREVIEW / etf_1hour / 2009-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-04.parquet
  size:    130 KB
  rows:    4,043

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
2009-03-04 04:00:00	SPY	ETF	70.68	71.03	70.68	71.03	20186.0
2009-03-04 05:00:00	SPY	ETF	70.85	70.94	70.69	70.82	4086.0
2009-03-04 06:00:00	SPY	ETF	70.81	70.82	70.6	70.8	57909.0
2009-03-04 07:00:00	SPY	ETF	70.82	70.82	70.41	70.44	2389244.0
2009-03-04 08:00:00	SPY	ETF	70.45	71.25	70.27	71.17	7426928.0
2009-03-04 09:00:00	SPY	ETF	71.17	71.58	70.81	70.89	63537182.0
2009-03-04 10:00:00	SPY	ETF	70.895	71.44	70.41	71.2	77122724.0
2009-03-04 11:00:00	SPY	ETF	71.19	71.95	71.19	71.81	52089866.0
2009-03-04 12:00:00	SPY	ETF	71.81	71.89	71.03	71.22	37531576.0
2009-03-04 13:00:00	SPY	ETF	71.22	71.64	70.0729	71.32	43214067.0
2009-03-04 14:00:00	SPY	ETF	71.32	72.48	71.21	72.41	58378534.0
2009-03-04 15:00:00	SPY	ETF	72.41	72.87	70.7	71.73	93695745.0
2009-03-04 16:00:00	SPY	ETF	71.74	72.439	70.95	71.46	23189328.0
2009-03-04 17:00:00	SPY	ETF	71.46	71.58	69.67	71.54	2041085.0
2009-03-04 18:00:00	SPY	ETF	71.54	71.57	71.36	71.38	715583.0
2009-03-04 19:00:00	SPY	ETF	71.38	71.68	71.3	71.44	97646.0
2009-03-04 04:00:00	QQQ	ETF	26.79	26.87	26.79	26.87	3444.0
2009-03-04 06:00:00	QQQ	ETF	26.83	26.83	26.79	26.81	7200.0
2009-03-04 07:00:00	QQQ	ETF	26.79	26.84	26.71	26.74	753777.0
2009-03-04 08:00:00	QQQ	ETF	26.74	27.04	26.7	27.01	5605699.0
2009-03-04 09:00:00	QQQ	ETF	26.99	27.23	26.89	27.06	20340839.0
2009-03-04 10:00:00	QQQ	ETF	27.06	27.35	26.99	27.289	23527803.0
2009-03-04 11:00:00	QQQ	ETF	27.281	27.52	27.09	27.47	19094570.0
2009-03-04 12:00:00	QQQ	ETF	27.47	27.51	27.24	27.29	15888425.0
2009-03-04 13:00:00	QQQ	ETF	27.29	27.4722	27.17	27.3401	13686819.0
2009-03-04 14:00:00	QQQ	ETF	27.35	27.65	27.31	27.63	21684084.0
2009-03-04 15:00:00	QQQ	ETF	27.62	27.71	27.29	27.32	34919765.0
2009-03-04 16:00:00	QQQ	ETF	27.33	27.68	27.15	27.24	5230215.0
2009-03-04 17:00:00	QQQ	ETF	27.25	27.3	27.24	27.27	32198.0
2009-03-04 18:00:00	QQQ	ETF	27.27	27.28	27.2	27.23	55042.0
2009-03-04 19:00:00	QQQ	ETF	27.21	27.3	27.19	27.27	68983.0
2009-03-04 04:00:00	IWM	ETF	36.58	36.58	36.58	36.58	200.0
2009-03-04 07:00:00	IWM	ETF	36.6	36.63	36.37	36.46	214447.0
2009-03-04 08:00:00	IWM	ETF	36.49	37.0	36.35	36.87	520896.0
2009-03-04 09:00:00	IWM	ETF	36.86	37.08	36.53	36.56	8984351.0
2009-03-04 10:00:00	IWM	ETF	36.58	36.81	36.22	36.58	9568592.0
2009-03-04 11:00:00	IWM	ETF	36.59	37.16	36.58	37.04	10429688.0
2009-03-04 12:00:00	IWM	ETF	37.04	37.13	36.571	36.642	6350261.0
2009-03-04 13:00:00	IWM	ETF	36.642	36.91	36.47	36.7001	8144239.0
2009-03-04 14:00:00	IWM	ETF	36.7	37.41	36.635	37.38	11391726.0
2009-03-04 15:00:00	IWM	ETF	37.38	37.65	37.03	37.07	15840758.0
2009-03-04 16:00:00	IWM	ETF	37.07	37.2067	36.1368	36.85	5478103.0
2009-03-04 17:00:00	IWM	ETF	36.85	36.87	36.82	36.87	24455.0
2009-03-04 18:00:00	IWM	ETF	36.9	36.9	36.9	36.9	1124.0
2009-03-04 19:00:00	IWM	ETF	36.93	36.94	36.9	36.94	10300.0
2009-03-04 04:00:00	DIA	ETF	67.77	67.77	67.77	67.77	286.0
2009-03-04 05:00:00	DIA	ETF	67.8	67.8	67.8	67.8	100.0
2009-03-04 06:00:00	DIA	ETF	67.98	67.98	67.91	67.93	800.0
2009-03-04 07:00:00	DIA	ETF	67.99	68.08	67.81	67.86	66941.0
2009-03-04 08:00:00	DIA	ETF	67.81	68.35	67.67	68.35	306873.0

> showing 50 of 4,043 rows — these rows as CSV

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