PREVIEW / etf_1hour / 2009-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-13.parquet
  size:    123 KB
  rows:    3,845

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-02-13 04:00:00	SPY	ETF	84.09	84.35	84.09	84.28	2231.0
2009-02-13 05:00:00	SPY	ETF	84.25	84.26	84.03	84.03	11000.0
2009-02-13 06:00:00	SPY	ETF	83.95	84.09	83.72	83.9	119400.0
2009-02-13 07:00:00	SPY	ETF	83.92	84.38	83.9	84.18	423253.0
2009-02-13 08:00:00	SPY	ETF	84.17	84.33	83.4	83.41	2865484.0
2009-02-13 09:00:00	SPY	ETF	83.41	84.1	83.06	83.54	34266878.0
2009-02-13 10:00:00	SPY	ETF	83.54	84.24	83.29	83.98	45814801.0
2009-02-13 11:00:00	SPY	ETF	83.99	84.01	83.07	83.08	32608255.0
2009-02-13 12:00:00	SPY	ETF	83.08	83.42	82.75	82.91	29695600.0
2009-02-13 13:00:00	SPY	ETF	82.9	84.01	82.82	83.79	32524162.0
2009-02-13 14:00:00	SPY	ETF	83.79	83.98	83.37	83.54	40370197.0
2009-02-13 15:00:00	SPY	ETF	83.54	84.0	82.78	82.78	56373747.0
2009-02-13 16:00:00	SPY	ETF	82.75	82.9547	82.35	82.51	10549309.0
2009-02-13 17:00:00	SPY	ETF	82.5	82.57	82.39	82.48	830294.0
2009-02-13 18:00:00	SPY	ETF	82.51	82.68	82.5	82.65	150379.0
2009-02-13 19:00:00	SPY	ETF	82.62	82.64	82.54	82.55	30503.0
2009-02-13 04:00:00	QQQ	ETF	30.83	30.87	30.83	30.87	775.0
2009-02-13 05:00:00	QQQ	ETF	30.85	30.86	30.85	30.86	637.0
2009-02-13 06:00:00	QQQ	ETF	30.79	30.79	30.74	30.74	18000.0
2009-02-13 07:00:00	QQQ	ETF	30.8	30.89	30.74	30.78	114711.0
2009-02-13 08:00:00	QQQ	ETF	30.81	30.81	30.49	30.49	1365660.0
2009-02-13 09:00:00	QQQ	ETF	30.49	30.63	30.29	30.5111	20487812.0
2009-02-13 10:00:00	QQQ	ETF	30.51	30.78	30.37	30.72	21815815.0
2009-02-13 11:00:00	QQQ	ETF	30.7201	30.7299	30.43	30.43	17345951.0
2009-02-13 12:00:00	QQQ	ETF	30.43	30.56	30.3	30.3685	12711519.0
2009-02-13 13:00:00	QQQ	ETF	30.37	30.73	30.33	30.66	18730780.0
2009-02-13 14:00:00	QQQ	ETF	30.66	30.74	30.53	30.62	16874926.0
2009-02-13 15:00:00	QQQ	ETF	30.63	30.69	30.41	30.42	26886412.0
2009-02-13 16:00:00	QQQ	ETF	30.43	30.43	30.23	30.28	7812531.0
2009-02-13 17:00:00	QQQ	ETF	30.27	30.29	30.23	30.28	57261.0
2009-02-13 18:00:00	QQQ	ETF	30.28	30.28	30.26	30.28	14049.0
2009-02-13 19:00:00	QQQ	ETF	30.28	30.28	30.2	30.2	47092.0
2009-02-13 04:00:00	IWM	ETF	45.39	45.39	45.39	45.39	200.0
2009-02-13 07:00:00	IWM	ETF	45.34	45.58	45.34	45.46	32377.0
2009-02-13 08:00:00	IWM	ETF	45.5	45.51	45.02	45.05	183508.0
2009-02-13 09:00:00	IWM	ETF	45.02	45.29	44.85	45.2	5671700.0
2009-02-13 10:00:00	IWM	ETF	45.2	45.7	44.98	45.6125	9887310.0
2009-02-13 11:00:00	IWM	ETF	45.59	45.6	44.92	44.99	5857859.0
2009-02-13 12:00:00	IWM	ETF	45.0	45.26	44.68	44.76	6069462.0
2009-02-13 13:00:00	IWM	ETF	44.75	45.48	44.72	45.24	6569073.0
2009-02-13 14:00:00	IWM	ETF	45.24	45.39	44.88	44.96	7250112.0
2009-02-13 15:00:00	IWM	ETF	44.96	45.19	44.58	44.6	12387169.0
2009-02-13 16:00:00	IWM	ETF	44.58	45.0183	44.34	44.57	4962528.0
2009-02-13 17:00:00	IWM	ETF	44.55	44.58	44.46	44.58	6900.0
2009-02-13 18:00:00	IWM	ETF	44.46	44.5	44.46	44.5	484.0
2009-02-13 19:00:00	IWM	ETF	44.57	44.57	44.56	44.56	684.0
2009-02-13 04:00:00	DIA	ETF	80.02	80.02	80.02	80.02	600.0
2009-02-13 07:00:00	DIA	ETF	79.71	80.04	79.71	79.96	15214.0
2009-02-13 08:00:00	DIA	ETF	79.93	79.98	79.36	79.37	65540.0
2009-02-13 09:00:00	DIA	ETF	79.29	79.68	78.93	79.32	3376009.0

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

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