PREVIEW / etf_1hour / 2009-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-30.parquet
  size:    151 KB
  rows:    4,630

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-10-30 04:00:00	SPY	ETF	106.24	106.33	106.08	106.33	2706.0
2009-10-30 05:00:00	SPY	ETF	106.38	106.5	106.21	106.21	2500.0
2009-10-30 06:00:00	SPY	ETF	106.28	106.28	106.25	106.25	2550.0
2009-10-30 07:00:00	SPY	ETF	106.28	106.34	106.08	106.25	448658.0
2009-10-30 08:00:00	SPY	ETF	106.26	106.65	105.96	106.14	2587919.0
2009-10-30 09:00:00	SPY	ETF	106.14	106.62	105.74	105.91	41087566.0
2009-10-30 10:00:00	SPY	ETF	105.92	106.38	105.62	106.02	31260920.0
2009-10-30 11:00:00	SPY	ETF	106.02	106.03	104.7	104.99	35384659.0
2009-10-30 12:00:00	SPY	ETF	104.99	105.27	103.8	103.96	52501512.0
2009-10-30 13:00:00	SPY	ETF	103.96	104.405	103.59	103.91	36532387.0
2009-10-30 14:00:00	SPY	ETF	103.9	104.52	103.73	104.02	33940879.0
2009-10-30 15:00:00	SPY	ETF	104.02	104.32	103.44	103.63	74506828.0
2009-10-30 16:00:00	SPY	ETF	103.64	106.34	103.45	103.73	15353009.0
2009-10-30 17:00:00	SPY	ETF	103.73	103.76	103.56	103.7	232492.0
2009-10-30 18:00:00	SPY	ETF	103.7	103.8	103.65	103.8	44170.0
2009-10-30 19:00:00	SPY	ETF	103.8	103.8	103.69	103.7	29660.0
2009-10-30 07:00:00	QQQ	ETF	42.0	42.01	41.91	41.97	19900.0
2009-10-30 08:00:00	QQQ	ETF	41.98	42.09	41.86	41.98	725362.0
2009-10-30 09:00:00	QQQ	ETF	41.97	42.15	41.83	41.96	21213968.0
2009-10-30 10:00:00	QQQ	ETF	41.965	42.14	41.86	42.01	17609816.0
2009-10-30 11:00:00	QQQ	ETF	42.01	42.02	41.34	41.47	18857257.0
2009-10-30 12:00:00	QQQ	ETF	41.47	41.56	41.02	41.1	26684084.0
2009-10-30 13:00:00	QQQ	ETF	41.09	41.26	40.95	41.12	22772889.0
2009-10-30 14:00:00	QQQ	ETF	41.12	41.32	41.03	41.17	16281307.0
2009-10-30 15:00:00	QQQ	ETF	41.16	41.25	40.92	40.97	29243110.0
2009-10-30 16:00:00	QQQ	ETF	40.96	41.5575	40.89	40.95	4874631.0
2009-10-30 17:00:00	QQQ	ETF	40.95	40.97	40.91	40.91	23510.0
2009-10-30 18:00:00	QQQ	ETF	41.01	41.01	40.9	40.94	77641.0
2009-10-30 19:00:00	QQQ	ETF	40.91	40.96	40.91	40.93	8401.0
2009-10-30 07:00:00	IWM	ETF	57.62	57.62	57.5	57.6	185299.0
2009-10-30 08:00:00	IWM	ETF	57.65	57.91	57.41	57.57	512002.0
2009-10-30 09:00:00	IWM	ETF	57.56	57.74	57.07	57.16	15935916.0
2009-10-30 10:00:00	IWM	ETF	57.17	57.47	56.99	57.35	11868706.0
2009-10-30 11:00:00	IWM	ETF	57.3599	57.41	56.57	56.82	12701071.0
2009-10-30 12:00:00	IWM	ETF	56.81	57.04	56.11	56.2699	16198246.0
2009-10-30 13:00:00	IWM	ETF	56.26	56.55	55.98	56.191	8350851.0
2009-10-30 14:00:00	IWM	ETF	56.2	56.59	56.19	56.4099	8496839.0
2009-10-30 15:00:00	IWM	ETF	56.4	56.7398	56.09	56.34	23130388.0
2009-10-30 16:00:00	IWM	ETF	56.33	58.0727	56.21	58.0727	12327047.0
2009-10-30 17:00:00	IWM	ETF	56.4	58.0726	56.32	56.42	1018241.0
2009-10-30 18:00:00	IWM	ETF	56.38	56.38	56.32	56.32	1900.0
2009-10-30 19:00:00	IWM	ETF	56.38	56.38	56.38	56.38	1000.0
2009-10-30 07:00:00	DIA	ETF	99.31	99.4	99.19	99.2	1790.0
2009-10-30 08:00:00	DIA	ETF	99.3	99.47	99.09	99.18	38019.0
2009-10-30 09:00:00	DIA	ETF	99.16	99.64	98.77	98.89	2984702.0
2009-10-30 10:00:00	DIA	ETF	98.88	99.25	98.68	99.009	3309357.0
2009-10-30 11:00:00	DIA	ETF	99.0	99.04	97.92	98.16	2962762.0
2009-10-30 12:00:00	DIA	ETF	98.17	98.35	97.11	97.3	5093999.0
2009-10-30 13:00:00	DIA	ETF	97.32	97.67	96.92	97.21	3668996.0
2009-10-30 14:00:00	DIA	ETF	97.22	97.7	97.09	97.35	2594170.0

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

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