PREVIEW / etf_1hour / 2006-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-28.parquet
  size:    41 KB
  rows:    1,272

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
2006-03-28 07:00:00	SPY	ETF	130.15	130.15	129.98	129.98	12300.0
2006-03-28 08:00:00	SPY	ETF	130.0	130.15	129.91	129.92	519700.0
2006-03-28 09:00:00	SPY	ETF	129.93	130.12	129.88	130.02	4254800.0
2006-03-28 10:00:00	SPY	ETF	130.02	130.09	129.88	129.98	5782400.0
2006-03-28 11:00:00	SPY	ETF	129.98	130.08	129.89	130.06	3076100.0
2006-03-28 12:00:00	SPY	ETF	130.05	130.53	130.0412	130.43	7531100.0
2006-03-28 13:00:00	SPY	ETF	130.45	130.45	130.23	130.33	3340200.0
2006-03-28 14:00:00	SPY	ETF	130.33	130.44	129.35	129.56	29180600.0
2006-03-28 15:00:00	SPY	ETF	129.56	129.75	129.05	129.22	22299800.0
2006-03-28 16:00:00	SPY	ETF	129.22	130.1019	129.17	129.19	2149700.0
2006-03-28 17:00:00	SPY	ETF	129.19	129.22	129.14	129.15	19400.0
2006-03-28 18:00:00	SPY	ETF	129.13	129.18	129.1	129.15	6500.0
2006-03-28 19:00:00	SPY	ETF	129.19	129.2	129.17	129.17	6300.0
2006-03-28 09:00:00	QQQ	ETF	41.37	41.47	41.33	41.41	5964000.0
2006-03-28 10:00:00	QQQ	ETF	41.41	41.49	41.34	41.44	11479700.0
2006-03-28 11:00:00	QQQ	ETF	41.44	41.47	41.4	41.44	3731600.0
2006-03-28 12:00:00	QQQ	ETF	41.44	41.67	41.43	41.58	10781400.0
2006-03-28 13:00:00	QQQ	ETF	41.58	41.59	41.45	41.53	4313100.0
2006-03-28 14:00:00	QQQ	ETF	41.54	41.59	41.18	41.23	27309100.0
2006-03-28 15:00:00	QQQ	ETF	41.24	41.25	40.99	41.13	32439900.0
2006-03-28 08:00:00	IWM	ETF	75.35	75.35	74.74	74.76	3500.0
2006-03-28 09:00:00	IWM	ETF	74.78	74.89	74.74	74.77	837300.0
2006-03-28 10:00:00	IWM	ETF	74.77	74.95	74.71	74.89	3108200.0
2006-03-28 11:00:00	IWM	ETF	74.89	75.02	74.84	74.99	1993600.0
2006-03-28 12:00:00	IWM	ETF	74.99	75.3	74.99	75.22	3841100.0
2006-03-28 13:00:00	IWM	ETF	75.22	75.24	74.8417	75.16	2576200.0
2006-03-28 14:00:00	IWM	ETF	75.15	75.2	74.55	74.7	7345700.0
2006-03-28 15:00:00	IWM	ETF	74.7	74.72	74.33	74.53	6514600.0
2006-03-28 16:00:00	IWM	ETF	74.53	74.7	74.53	74.58	242800.0
2006-03-28 17:00:00	IWM	ETF	74.56	74.65	74.53	74.65	200500.0
2006-03-28 19:00:00	IWM	ETF	74.56	74.56	74.56	74.56	100.0
2006-03-28 08:00:00	DIA	ETF	112.35	112.4	112.31	112.32	4800.0
2006-03-28 09:00:00	DIA	ETF	112.33	112.53	112.3	112.48	169300.0
2006-03-28 10:00:00	DIA	ETF	112.48	112.5	112.25	112.35	665900.0
2006-03-28 11:00:00	DIA	ETF	112.36	112.4	112.27	112.3602	214700.0
2006-03-28 12:00:00	DIA	ETF	112.36	112.72	112.36	112.67	891400.0
2006-03-28 13:00:00	DIA	ETF	112.66	112.67	112.43	112.5	349200.0
2006-03-28 14:00:00	DIA	ETF	112.5	112.62	111.63	111.8	3376400.0
2006-03-28 15:00:00	DIA	ETF	111.8	111.81	111.32	111.4601	2504400.0
2006-03-28 16:00:00	DIA	ETF	111.47	111.51	111.38	111.42	194600.0
2006-03-28 17:00:00	DIA	ETF	111.39	111.45	111.39	111.42	9200.0
2006-03-28 18:00:00	DIA	ETF	111.4	111.43	111.4	111.43	1100.0
2006-03-28 19:00:00	DIA	ETF	111.44	111.45	111.44	111.45	1100.0
2006-03-28 07:00:00	GLD	ETF	56.25	56.25	56.21	56.21	200.0
2006-03-28 08:00:00	GLD	ETF	56.25	56.5	56.23	56.46	30200.0
2006-03-28 09:00:00	GLD	ETF	56.48	56.68	56.45	56.45	629900.0
2006-03-28 10:00:00	GLD	ETF	56.45	56.54	56.34	56.49	561900.0
2006-03-28 11:00:00	GLD	ETF	56.49	56.63	56.45	56.51	320500.0
2006-03-28 12:00:00	GLD	ETF	56.51	56.56	56.37	56.45	179100.0
2006-03-28 13:00:00	GLD	ETF	56.45	56.4576	56.3	56.32	302900.0

> showing 50 of 1,272 rows — these rows as CSV

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