PREVIEW / etf_1hour / 2008-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-06.parquet
  size:    121 KB
  rows:    3,952

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
2008-10-06 04:00:00	SPY	ETF	107.72	107.75	107.31	107.31	4400.0
2008-10-06 05:00:00	SPY	ETF	107.49	107.53	106.86	107.05	22400.0
2008-10-06 06:00:00	SPY	ETF	107.05	108.28	106.96	107.66	277400.0
2008-10-06 07:00:00	SPY	ETF	107.75	108.09	107.24	107.78	2326864.0
2008-10-06 08:00:00	SPY	ETF	107.78	109.62	107.08	107.69	7322360.0
2008-10-06 09:00:00	SPY	ETF	107.7	108.45	105.77	106.15	55460816.0
2008-10-06 10:00:00	SPY	ETF	106.15	107.05	102.53	104.34	98987771.0
2008-10-06 11:00:00	SPY	ETF	104.35	105.62	103.94	104.31	77073552.0
2008-10-06 12:00:00	SPY	ETF	104.31	104.79	103.16	103.3596	35674000.0
2008-10-06 13:00:00	SPY	ETF	103.35	107.22	102.62	103.29	48366380.0
2008-10-06 14:00:00	SPY	ETF	103.29	104.2398	100.64	101.93	91045617.0
2008-10-06 15:00:00	SPY	ETF	101.94	106.44	101.31	106.27	155394203.0
2008-10-06 16:00:00	SPY	ETF	106.25	109.8553	103.5149	104.58	30184185.0
2008-10-06 17:00:00	SPY	ETF	104.58	109.86	104.48	104.9	2561284.0
2008-10-06 18:00:00	SPY	ETF	104.85	104.85	104.42	104.81	283430.0
2008-10-06 19:00:00	SPY	ETF	104.83	104.95	104.46	104.6	108305.0
2008-10-06 04:00:00	QQQ	ETF	35.28	35.39	35.2	35.39	6200.0
2008-10-06 05:00:00	QQQ	ETF	35.43	35.43	35.0	35.0	10200.0
2008-10-06 06:00:00	QQQ	ETF	35.13	35.49	35.13	35.38	13700.0
2008-10-06 07:00:00	QQQ	ETF	35.5	35.64	35.29	35.56	231688.0
2008-10-06 08:00:00	QQQ	ETF	35.56	35.85	35.21	35.47	3074855.0
2008-10-06 09:00:00	QQQ	ETF	35.51	35.71	34.51	34.68	34985882.0
2008-10-06 10:00:00	QQQ	ETF	34.68	34.821	33.37	34.3	57328538.0
2008-10-06 11:00:00	QQQ	ETF	34.29	34.6	33.97	34.02	42354474.0
2008-10-06 12:00:00	QQQ	ETF	34.02	34.2	33.69	33.72	23672848.0
2008-10-06 13:00:00	QQQ	ETF	33.722	34.02	33.36	33.6404	37365976.0
2008-10-06 14:00:00	QQQ	ETF	33.64	33.6699	32.91	33.35	56057076.0
2008-10-06 15:00:00	QQQ	ETF	33.35	34.96	33.12	34.89	111400557.0
2008-10-06 16:00:00	QQQ	ETF	34.89	34.94	34.0418	34.32	11196334.0
2008-10-06 17:00:00	QQQ	ETF	34.3	34.86	34.28	34.44	530961.0
2008-10-06 18:00:00	QQQ	ETF	34.45	34.87	34.35	34.43	4129430.0
2008-10-06 19:00:00	QQQ	ETF	34.42	34.49	34.4	34.43	76341.0
2008-10-06 06:00:00	IWM	ETF	60.36	60.36	60.36	60.36	1200.0
2008-10-06 07:00:00	IWM	ETF	60.32	60.67	60.0	60.51	61752.0
2008-10-06 08:00:00	IWM	ETF	61.29	61.29	60.36	60.55	508694.0
2008-10-06 09:00:00	IWM	ETF	60.51	60.76	59.65	59.8	16890521.0
2008-10-06 10:00:00	IWM	ETF	59.8	59.85	57.81	58.88	29740656.0
2008-10-06 11:00:00	IWM	ETF	58.88	59.62	58.64	58.98	22129802.0
2008-10-06 12:00:00	IWM	ETF	58.97	59.37	58.2	58.41	12293450.0
2008-10-06 13:00:00	IWM	ETF	58.41	59.4	57.72	58.1	14290093.0
2008-10-06 14:00:00	IWM	ETF	58.1	58.11	56.38	57.19	24605321.0
2008-10-06 15:00:00	IWM	ETF	57.19	60.02	56.88	59.73	41719041.0
2008-10-06 16:00:00	IWM	ETF	59.73	59.86	56.84	59.24	5371465.0
2008-10-06 17:00:00	IWM	ETF	59.26	61.84	59.26	59.38	1010056.0
2008-10-06 18:00:00	IWM	ETF	59.36	59.38	59.32	59.32	1200.0
2008-10-06 19:00:00	IWM	ETF	59.34	59.4	59.33	59.4	300.0
2008-10-06 06:00:00	DIA	ETF	101.0	101.0	101.0	101.0	1000.0
2008-10-06 07:00:00	DIA	ETF	101.25	102.24	101.0	101.3	5300.0
2008-10-06 08:00:00	DIA	ETF	101.4	101.99	101.0	101.32	49120.0
2008-10-06 09:00:00	DIA	ETF	101.4	101.56	99.94	100.24	3363139.0

> showing 50 of 3,952 rows — these rows as CSV

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