PREVIEW / etf_1hour / 2009-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-27.parquet
  size:    135 KB
  rows:    4,157

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-04-27 04:00:00	SPY	ETF	85.52	85.69	85.52	85.69	2100.0
2009-04-27 05:00:00	SPY	ETF	85.74	85.74	85.36	85.56	21830.0
2009-04-27 06:00:00	SPY	ETF	85.54	85.73	85.36	85.44	53649.0
2009-04-27 07:00:00	SPY	ETF	85.44	85.83	85.42	85.64	993728.0
2009-04-27 08:00:00	SPY	ETF	85.62	85.65	85.29	85.55	3051600.0
2009-04-27 09:00:00	SPY	ETF	85.54	86.3	85.43	86.1794	30960879.0
2009-04-27 10:00:00	SPY	ETF	86.18	86.87	85.65	86.84	56790597.0
2009-04-27 11:00:00	SPY	ETF	86.84	86.98	86.55	86.84	25906365.0
2009-04-27 12:00:00	SPY	ETF	86.85	87.01	86.25	86.4	26053718.0
2009-04-27 13:00:00	SPY	ETF	86.4	86.43	85.54	85.74	31593062.0
2009-04-27 14:00:00	SPY	ETF	85.74	86.08	85.54	85.96	31380197.0
2009-04-27 15:00:00	SPY	ETF	85.96	86.37	85.58	85.85	61370596.0
2009-04-27 16:00:00	SPY	ETF	85.86	86.4501	85.56	85.73	18280264.0
2009-04-27 17:00:00	SPY	ETF	85.71	85.81	85.64	85.8	1308534.0
2009-04-27 18:00:00	SPY	ETF	85.77	85.77	85.63	85.68	141410.0
2009-04-27 19:00:00	SPY	ETF	85.67	85.76	85.65	85.68	42712.0
2009-04-27 04:00:00	QQQ	ETF	33.32	33.32	33.32	33.32	475.0
2009-04-27 05:00:00	QQQ	ETF	33.37	33.37	33.29	33.37	1811.0
2009-04-27 06:00:00	QQQ	ETF	33.34	33.4	33.31	33.36	233769.0
2009-04-27 07:00:00	QQQ	ETF	33.37	33.44	33.32	33.4	120344.0
2009-04-27 08:00:00	QQQ	ETF	33.39	33.41	33.3	33.36	581948.0
2009-04-27 09:00:00	QQQ	ETF	33.37	33.83	33.34	33.74	17703609.0
2009-04-27 10:00:00	QQQ	ETF	33.75	34.04	33.58	34.01	26060978.0
2009-04-27 11:00:00	QQQ	ETF	34.01	34.06	33.9	33.97	9548916.0
2009-04-27 12:00:00	QQQ	ETF	33.98	34.05	33.8	33.84	8423289.0
2009-04-27 13:00:00	QQQ	ETF	33.8302	33.845	33.57	33.66	13057288.0
2009-04-27 14:00:00	QQQ	ETF	33.65	33.75	33.41	33.71	11388746.0
2009-04-27 15:00:00	QQQ	ETF	33.71	33.86	33.58	33.71	21333253.0
2009-04-27 16:00:00	QQQ	ETF	33.71	33.83	33.67	33.68	9477483.0
2009-04-27 17:00:00	QQQ	ETF	33.71	33.76	33.68	33.71	233367.0
2009-04-27 18:00:00	QQQ	ETF	33.71	33.72	33.67	33.67	71601.0
2009-04-27 19:00:00	QQQ	ETF	33.68	33.73	33.67	33.71	35989.0
2009-04-27 06:00:00	IWM	ETF	47.0	47.0	46.83	46.83	1400.0
2009-04-27 07:00:00	IWM	ETF	46.89	47.05	46.81	46.9	18400.0
2009-04-27 08:00:00	IWM	ETF	46.9	46.94	46.74	46.83	128973.0
2009-04-27 09:00:00	IWM	ETF	46.83	47.31	46.69	47.21	7795491.0
2009-04-27 10:00:00	IWM	ETF	47.21	47.53	46.83	47.52	9236603.0
2009-04-27 11:00:00	IWM	ETF	47.52	47.72	47.4	47.66	5261226.0
2009-04-27 12:00:00	IWM	ETF	47.67	47.79	47.16	47.28	4698111.0
2009-04-27 13:00:00	IWM	ETF	47.28	47.285	46.68	46.82	6138613.0
2009-04-27 14:00:00	IWM	ETF	46.81	47.01	46.61	46.94	5689219.0
2009-04-27 15:00:00	IWM	ETF	46.945	47.33	46.67	47.08	9213141.0
2009-04-27 16:00:00	IWM	ETF	47.08	47.26	46.91	46.98	829081.0
2009-04-27 17:00:00	IWM	ETF	46.96	47.02	46.95	47.02	3019.0
2009-04-27 18:00:00	IWM	ETF	46.9	46.9	46.9	46.9	100.0
2009-04-27 19:00:00	IWM	ETF	46.87	46.99	46.87	46.99	300.0
2009-04-27 04:00:00	DIA	ETF	80.67	80.67	80.67	80.67	100.0
2009-04-27 06:00:00	DIA	ETF	79.79	79.79	79.58	79.6	1400.0
2009-04-27 07:00:00	DIA	ETF	79.64	79.91	79.6	79.84	6058.0
2009-04-27 08:00:00	DIA	ETF	79.81	79.81	79.55	79.63	149577.0

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

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