PREVIEW / etf_1hour / 2009-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-02.parquet
  size:    146 KB
  rows:    4,527

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-11-02 04:00:00	SPY	ETF	104.35	104.49	104.25	104.25	3013.0
2009-11-02 05:00:00	SPY	ETF	104.43	104.49	104.35	104.48	8500.0
2009-11-02 06:00:00	SPY	ETF	104.35	104.52	104.35	104.47	30736.0
2009-11-02 07:00:00	SPY	ETF	104.41	104.47	104.16	104.24	670511.0
2009-11-02 08:00:00	SPY	ETF	103.85	104.57	103.85	104.17	753536.0
2009-11-02 09:00:00	SPY	ETF	104.16	104.52	103.56	104.44	31503879.0
2009-11-02 10:00:00	SPY	ETF	104.44	105.41	104.345	104.7	52627232.0
2009-11-02 11:00:00	SPY	ETF	104.69	105.18	104.57	104.9	21315126.0
2009-11-02 12:00:00	SPY	ETF	104.9	104.95	103.15	103.17	34277156.0
2009-11-02 13:00:00	SPY	ETF	103.17	104.88	103.08	103.26	27726320.0
2009-11-02 14:00:00	SPY	ETF	103.25	104.22	103.08	103.92	35146945.0
2009-11-02 15:00:00	SPY	ETF	103.92	104.49	103.62	104.36	39565997.0
2009-11-02 16:00:00	SPY	ETF	104.32	105.16	103.45	104.57	10180049.0
2009-11-02 17:00:00	SPY	ETF	104.57	104.64	104.5	104.5	193597.0
2009-11-02 18:00:00	SPY	ETF	104.54	104.57	104.48	104.49	115440.0
2009-11-02 19:00:00	SPY	ETF	104.52	104.84	104.52	104.76	222854.0
2009-11-02 04:00:00	QQQ	ETF	41.14	41.19	41.12	41.16	1119.0
2009-11-02 05:00:00	QQQ	ETF	41.11	41.17	41.11	41.17	200.0
2009-11-02 06:00:00	QQQ	ETF	41.19	41.19	41.13	41.13	10100.0
2009-11-02 07:00:00	QQQ	ETF	41.16	41.16	41.05	41.09	111563.0
2009-11-02 08:00:00	QQQ	ETF	40.97	41.21	40.96	41.09	429439.0
2009-11-02 09:00:00	QQQ	ETF	41.1	41.13	40.77	41.04	18477183.0
2009-11-02 10:00:00	QQQ	ETF	41.03	41.57	41.03	41.25	36144884.0
2009-11-02 11:00:00	QQQ	ETF	41.25	41.45	41.2	41.361	12469403.0
2009-11-02 12:00:00	QQQ	ETF	41.361	41.385	40.73	40.782	19708730.0
2009-11-02 13:00:00	QQQ	ETF	40.78	41.06	40.75	40.79	13869865.0
2009-11-02 14:00:00	QQQ	ETF	40.78	41.12	40.64	41.03	19160335.0
2009-11-02 15:00:00	QQQ	ETF	41.04	41.18	40.88	41.13	18503882.0
2009-11-02 16:00:00	QQQ	ETF	41.12	41.19	41.1	41.17	1734055.0
2009-11-02 17:00:00	QQQ	ETF	41.18	41.19	41.16	41.16	9400.0
2009-11-02 18:00:00	QQQ	ETF	41.15	41.17	41.15	41.16	49810.0
2009-11-02 19:00:00	QQQ	ETF	41.17	41.27	41.17	41.22	55238.0
2009-11-02 06:00:00	IWM	ETF	56.87	56.94	56.87	56.94	541.0
2009-11-02 07:00:00	IWM	ETF	56.9	56.9	56.67	56.73	102690.0
2009-11-02 08:00:00	IWM	ETF	56.72	56.99	56.35	56.71	199157.0
2009-11-02 09:00:00	IWM	ETF	56.73	56.84	55.96	56.28	12155770.0
2009-11-02 10:00:00	IWM	ETF	56.28	57.14	56.25	56.5626	21657295.0
2009-11-02 11:00:00	IWM	ETF	56.55	56.87	56.45	56.68	7523142.0
2009-11-02 12:00:00	IWM	ETF	56.67	56.69	55.56	55.59	12104269.0
2009-11-02 13:00:00	IWM	ETF	55.6	56.03	55.49	55.51	11693059.0
2009-11-02 14:00:00	IWM	ETF	55.5	56.17	55.33	55.95	14045684.0
2009-11-02 15:00:00	IWM	ETF	55.95	56.31	55.55	56.27	13897289.0
2009-11-02 16:00:00	IWM	ETF	56.27	67.023	56.14	56.45	2705008.0
2009-11-02 17:00:00	IWM	ETF	56.41	56.42	56.38	56.42	10025.0
2009-11-02 18:00:00	IWM	ETF	56.4	56.41	56.36	56.36	600.0
2009-11-02 19:00:00	IWM	ETF	56.44	56.54	56.44	56.52	6450.0
2009-11-02 07:00:00	DIA	ETF	97.56	97.56	97.56	97.56	800.0
2009-11-02 08:00:00	DIA	ETF	97.54	97.63	97.48	97.48	13000.0
2009-11-02 09:00:00	DIA	ETF	97.48	97.93	97.25	97.88	1671502.0
2009-11-02 10:00:00	DIA	ETF	97.93	99.0	97.89	98.13	3411747.0

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

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