PREVIEW / etf_1hour / 2009-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-18.parquet
  size:    126 KB
  rows:    3,915

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-18 04:00:00	SPY	ETF	79.47	79.47	79.2	79.3	5000.0
2009-02-18 05:00:00	SPY	ETF	79.3	79.36	79.01	79.36	6900.0
2009-02-18 06:00:00	SPY	ETF	79.32	79.7	79.29	79.63	26100.0
2009-02-18 07:00:00	SPY	ETF	79.57	79.59	79.36	79.38	341882.0
2009-02-18 08:00:00	SPY	ETF	79.57	79.79	79.3	79.78	2902610.0
2009-02-18 09:00:00	SPY	ETF	79.78	80.1	79.0	79.04	38360085.0
2009-02-18 10:00:00	SPY	ETF	79.04	79.45	78.28	78.85	72534909.0
2009-02-18 11:00:00	SPY	ETF	78.85	79.78	78.65	79.5	46195442.0
2009-02-18 12:00:00	SPY	ETF	79.5	79.94	79.04	79.45	36546217.0
2009-02-18 13:00:00	SPY	ETF	79.43	79.67	78.7	78.87	36031409.0
2009-02-18 14:00:00	SPY	ETF	78.87	79.29	78.54	79.26	46759659.0
2009-02-18 15:00:00	SPY	ETF	79.25	79.44	78.87	79.06	63133258.0
2009-02-18 16:00:00	SPY	ETF	79.01	79.75	78.17	78.29	13054716.0
2009-02-18 17:00:00	SPY	ETF	78.27	78.36	78.12	78.18	1075108.0
2009-02-18 18:00:00	SPY	ETF	78.26	78.55	78.2	78.54	313264.0
2009-02-18 19:00:00	SPY	ETF	78.53	78.62	78.44	78.53	159645.0
2009-02-18 04:00:00	QQQ	ETF	29.24	29.24	29.16	29.21	8100.0
2009-02-18 06:00:00	QQQ	ETF	29.29	29.32	29.27	29.32	10300.0
2009-02-18 07:00:00	QQQ	ETF	29.3	29.3	29.21	29.25	104425.0
2009-02-18 08:00:00	QQQ	ETF	29.24	29.46	29.22	29.45	551755.0
2009-02-18 09:00:00	QQQ	ETF	29.43	29.54	29.16	29.19	13517262.0
2009-02-18 10:00:00	QQQ	ETF	29.19	29.36	28.87	29.24	29565452.0
2009-02-18 11:00:00	QQQ	ETF	29.25	29.62	29.19	29.5	20158324.0
2009-02-18 12:00:00	QQQ	ETF	29.49	29.6699	29.38	29.4801	16755106.0
2009-02-18 13:00:00	QQQ	ETF	29.48	29.55	29.17	29.21	18081071.0
2009-02-18 14:00:00	QQQ	ETF	29.22	29.4	29.1	29.3999	19496071.0
2009-02-18 15:00:00	QQQ	ETF	29.39	29.43	29.24	29.25	28942257.0
2009-02-18 16:00:00	QQQ	ETF	29.25	29.28	28.95	28.98	10588631.0
2009-02-18 17:00:00	QQQ	ETF	28.95	29.0	28.9	28.95	258085.0
2009-02-18 18:00:00	QQQ	ETF	28.97	29.02	28.93	29.02	136386.0
2009-02-18 19:00:00	QQQ	ETF	29.02	29.06	28.98	29.03	77650.0
2009-02-18 07:00:00	IWM	ETF	42.92	42.96	42.9	42.95	10000.0
2009-02-18 08:00:00	IWM	ETF	42.94	43.24	42.87	43.21	251795.0
2009-02-18 09:00:00	IWM	ETF	43.24	43.52	42.5	42.51	6958357.0
2009-02-18 10:00:00	IWM	ETF	42.51	42.68	42.13	42.4	15805677.0
2009-02-18 11:00:00	IWM	ETF	42.41	42.97	42.31	42.76	7448741.0
2009-02-18 12:00:00	IWM	ETF	42.76	43.05	42.35	42.71	9191254.0
2009-02-18 13:00:00	IWM	ETF	42.69	42.81	42.24	42.33	7412429.0
2009-02-18 14:00:00	IWM	ETF	42.33	42.54	42.15	42.53	8247430.0
2009-02-18 15:00:00	IWM	ETF	42.53	43.1	42.25	42.3	11223369.0
2009-02-18 16:00:00	IWM	ETF	42.3	42.8774	41.87	42.01	7559126.0
2009-02-18 17:00:00	IWM	ETF	42.04	42.06	41.97	41.97	9310.0
2009-02-18 18:00:00	IWM	ETF	42.03	42.03	41.99	41.99	4300.0
2009-02-18 19:00:00	IWM	ETF	41.99	42.08	41.99	42.07	1584.0
2009-02-18 06:00:00	DIA	ETF	75.81	76.11	75.81	76.11	600.0
2009-02-18 07:00:00	DIA	ETF	75.99	76.0	75.88	75.9	5800.0
2009-02-18 08:00:00	DIA	ETF	75.85	76.23	75.85	76.2	35716.0
2009-02-18 09:00:00	DIA	ETF	76.18	76.44	75.61	75.66	3728843.0
2009-02-18 10:00:00	DIA	ETF	75.66	75.94	75.09	75.58	7380536.0
2009-02-18 11:00:00	DIA	ETF	75.59	76.32	75.4	76.11	4217740.0

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

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