PREVIEW / etf_1hour / 2009-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-10.parquet
  size:    133 KB
  rows:    4,118

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-10 04:00:00	SPY	ETF	68.95	69.5	68.95	69.42	6910.0
2009-03-10 05:00:00	SPY	ETF	69.22	69.45	69.21	69.42	8300.0
2009-03-10 06:00:00	SPY	ETF	69.24	69.69	69.24	69.48	112130.0
2009-03-10 07:00:00	SPY	ETF	69.49	69.59	69.26	69.44	1289553.0
2009-03-10 08:00:00	SPY	ETF	69.44	69.64	68.75	69.32	4600284.0
2009-03-10 09:00:00	SPY	ETF	69.31	70.79	69.2	70.41	54377438.0
2009-03-10 10:00:00	SPY	ETF	70.41	71.31	70.4	71.05	66215723.0
2009-03-10 11:00:00	SPY	ETF	71.05	71.84	70.81	71.82	43945849.0
2009-03-10 12:00:00	SPY	ETF	71.83	72.08	71.57	71.59	41588881.0
2009-03-10 13:00:00	SPY	ETF	71.59	72.14	71.5	71.66	39029352.0
2009-03-10 14:00:00	SPY	ETF	71.6599	72.04	71.23	71.83	53308183.0
2009-03-10 15:00:00	SPY	ETF	71.83	72.37	71.55	72.23	75824583.0
2009-03-10 16:00:00	SPY	ETF	72.22	72.67	71.1	72.23	20421247.0
2009-03-10 17:00:00	SPY	ETF	72.23	72.38	72.2	72.27	418852.0
2009-03-10 18:00:00	SPY	ETF	72.25	72.35	72.2	72.31	136625.0
2009-03-10 19:00:00	SPY	ETF	72.31	72.34	72.19	72.32	182910.0
2009-03-10 04:00:00	QQQ	ETF	26.06	26.16	26.06	26.16	2850.0
2009-03-10 05:00:00	QQQ	ETF	26.16	26.16	26.1	26.1	400.0
2009-03-10 06:00:00	QQQ	ETF	26.21	26.27	26.21	26.25	146408.0
2009-03-10 07:00:00	QQQ	ETF	26.25	26.26	26.15	26.17	300341.0
2009-03-10 08:00:00	QQQ	ETF	26.16	26.27	26.13	26.15	2052645.0
2009-03-10 09:00:00	QQQ	ETF	26.15	26.74	26.14	26.52	27789954.0
2009-03-10 10:00:00	QQQ	ETF	26.52	27.0	26.52	26.89	28811902.0
2009-03-10 11:00:00	QQQ	ETF	26.89	27.14	26.7601	27.14	18500549.0
2009-03-10 12:00:00	QQQ	ETF	27.13	27.24	27.09	27.11	13914605.0
2009-03-10 13:00:00	QQQ	ETF	27.1121	27.33	27.098	27.17	13037660.0
2009-03-10 14:00:00	QQQ	ETF	27.161	27.25	27.0	27.19	15164286.0
2009-03-10 15:00:00	QQQ	ETF	27.19	27.39	26.75	27.32	30373108.0
2009-03-10 16:00:00	QQQ	ETF	27.32	27.43	25.7213	27.36	16227666.0
2009-03-10 17:00:00	QQQ	ETF	27.35	27.39	27.34	27.36	344935.0
2009-03-10 18:00:00	QQQ	ETF	27.33	27.37	27.33	27.37	18610.0
2009-03-10 19:00:00	QQQ	ETF	27.35	27.38	27.34	27.37	74971.0
2009-03-10 04:00:00	IWM	ETF	34.95	34.95	34.95	34.95	397.0
2009-03-10 06:00:00	IWM	ETF	35.3	35.3	35.3	35.3	330.0
2009-03-10 07:00:00	IWM	ETF	35.28	35.48	35.25	35.48	140836.0
2009-03-10 08:00:00	IWM	ETF	35.38	35.5	34.98	35.23	532337.0
2009-03-10 09:00:00	IWM	ETF	35.22	36.17	35.1	35.89	10302132.0
2009-03-10 10:00:00	IWM	ETF	35.88	36.51	35.87	36.17	9998431.0
2009-03-10 11:00:00	IWM	ETF	36.16	36.7214	36.03	36.36	5883103.0
2009-03-10 12:00:00	IWM	ETF	36.36	36.61	36.31	36.32	9753098.0
2009-03-10 13:00:00	IWM	ETF	36.31	36.57	36.3	36.4	5191867.0
2009-03-10 14:00:00	IWM	ETF	36.4	36.5	35.25	36.43	8305155.0
2009-03-10 15:00:00	IWM	ETF	36.42	36.81	35.25	36.68	16626925.0
2009-03-10 16:00:00	IWM	ETF	36.68	37.07	36.5	36.74	3328238.0
2009-03-10 17:00:00	IWM	ETF	36.74	36.77	36.74	36.74	94320.0
2009-03-10 18:00:00	IWM	ETF	36.74	36.8	36.74	36.74	4865.0
2009-03-10 19:00:00	IWM	ETF	36.74	36.74	36.74	36.74	1000.0
2009-03-10 04:00:00	DIA	ETF	66.19	66.44	66.19	66.44	400.0
2009-03-10 06:00:00	DIA	ETF	66.62	66.65	66.55	66.55	6060.0
2009-03-10 07:00:00	DIA	ETF	66.54	66.6	66.5	66.54	14000.0

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

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