PREVIEW / etf_1hour / 2006-03-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	129.17	129.17	129.17	129.17	14000.0
2006-03-06 05:00:00	SPY	ETF	129.25	129.25	129.25	129.25	100.0
2006-03-06 06:00:00	SPY	ETF	129.14	129.14	129.08	129.09	272000.0
2006-03-06 07:00:00	SPY	ETF	129.09	129.17	129.05	129.07	110600.0
2006-03-06 08:00:00	SPY	ETF	129.1	129.34	128.81	129.1	1530500.0
2006-03-06 09:00:00	SPY	ETF	129.1	129.18	128.68	128.86	7344200.0
2006-03-06 10:00:00	SPY	ETF	128.86	129.07	128.74	129.01	6673400.0
2006-03-06 11:00:00	SPY	ETF	129.0	129.13	128.86	128.98	3983500.0
2006-03-06 12:00:00	SPY	ETF	128.981	129.02	128.69	128.7805	3807000.0
2006-03-06 13:00:00	SPY	ETF	128.78	128.96	128.24	128.36	9536500.0
2006-03-06 14:00:00	SPY	ETF	128.35	128.36	127.85	128.01	10264300.0
2006-03-06 15:00:00	SPY	ETF	128.01	129.04	127.96	128.14	9750600.0
2006-03-06 16:00:00	SPY	ETF	128.15	128.503	128.03	128.08	1215600.0
2006-03-06 17:00:00	SPY	ETF	128.06	128.09	128.06	128.06	7200.0
2006-03-06 18:00:00	SPY	ETF	128.09	128.09	128.07	128.07	700.0
2006-03-06 19:00:00	SPY	ETF	128.1	128.1	128.1	128.1	300.0
2006-03-06 09:00:00	QQQ	ETF	41.53	41.54	41.35	41.48	16615000.0
2006-03-06 10:00:00	QQQ	ETF	41.47	41.57	41.41	41.55	11518800.0
2006-03-06 11:00:00	QQQ	ETF	41.54	41.63	41.48	41.58	8291600.0
2006-03-06 12:00:00	QQQ	ETF	41.57	41.59	41.45	41.47	4057800.0
2006-03-06 13:00:00	QQQ	ETF	41.47	41.55	41.08	41.14	15874300.0
2006-03-06 14:00:00	QQQ	ETF	41.14	41.45	40.96	41.06	14516100.0
2006-03-06 15:00:00	QQQ	ETF	41.06	41.45	41.03	41.09	15068200.0
2006-03-06 07:00:00	IWM	ETF	73.25	73.25	73.25	73.25	100.0
2006-03-06 08:00:00	IWM	ETF	73.32	73.37	73.32	73.37	63400.0
2006-03-06 09:00:00	IWM	ETF	73.39	73.43	72.79	73.0	3763200.0
2006-03-06 10:00:00	IWM	ETF	73.0	73.29	72.95	73.23	4981700.0
2006-03-06 11:00:00	IWM	ETF	73.23	73.46	73.18	73.26	3285300.0
2006-03-06 12:00:00	IWM	ETF	73.26	73.3351	73.02	73.03	2419000.0
2006-03-06 13:00:00	IWM	ETF	73.03	73.19	72.63	72.71	3639300.0
2006-03-06 14:00:00	IWM	ETF	72.71	72.72	72.44	72.53	4696100.0
2006-03-06 15:00:00	IWM	ETF	72.52	72.83	72.48	72.69	5293900.0
2006-03-06 16:00:00	IWM	ETF	72.7	72.73	72.49	72.69	295900.0
2006-03-06 17:00:00	IWM	ETF	72.65	72.65	72.65	72.65	2500.0
2006-03-06 18:00:00	IWM	ETF	72.62	72.62	72.62	72.62	4000.0
2006-03-06 07:00:00	DIA	ETF	110.21	110.21	109.5	109.5	600.0
2006-03-06 08:00:00	DIA	ETF	110.19	110.23	109.61	110.1	18300.0
2006-03-06 09:00:00	DIA	ETF	110.14	110.18	109.98	110.1	666700.0
2006-03-06 10:00:00	DIA	ETF	110.1	110.31	110.08	110.27	844200.0
2006-03-06 11:00:00	DIA	ETF	110.26	110.37	110.15	110.3	314900.0
2006-03-06 12:00:00	DIA	ETF	110.29	110.3	110.09	110.16	307800.0
2006-03-06 13:00:00	DIA	ETF	110.18	110.29	109.59	109.71	951000.0
2006-03-06 14:00:00	DIA	ETF	109.68	109.69	109.28	109.41	1127200.0
2006-03-06 15:00:00	DIA	ETF	109.41	109.69	109.37	109.6	1195900.0
2006-03-06 16:00:00	DIA	ETF	109.64	109.65	109.57	109.57	10700.0
2006-03-06 18:00:00	DIA	ETF	109.5	109.5	109.5	109.5	300.0
2006-03-06 07:00:00	GLD	ETF	56.4	56.4	56.3	56.3	2000.0
2006-03-06 08:00:00	GLD	ETF	56.39	56.4	56.2	56.2	12600.0
2006-03-06 09:00:00	GLD	ETF	56.25	56.45	56.25	56.34	419300.0
2006-03-06 10:00:00	GLD	ETF	56.33	56.37	56.2	56.28	489300.0

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

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