PREVIEW / etf_1hour / 2009-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-06.parquet
  size:    141 KB
  rows:    4,358

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-08-06 04:00:00	SPY	ETF	100.63	100.72	100.46	100.6	18850.0
2009-08-06 05:00:00	SPY	ETF	100.62	100.62	100.4	100.4	9200.0
2009-08-06 06:00:00	SPY	ETF	100.6	100.62	100.41	100.45	15400.0
2009-08-06 07:00:00	SPY	ETF	100.43	100.95	100.43	100.87	298062.0
2009-08-06 08:00:00	SPY	ETF	100.86	101.35	100.55	100.88	4145381.0
2009-08-06 09:00:00	SPY	ETF	100.88	101.02	100.15	100.22	30231320.0
2009-08-06 10:00:00	SPY	ETF	100.21	100.26	99.7	100.0601	34463721.0
2009-08-06 11:00:00	SPY	ETF	100.07	100.35	100.03	100.08	16957974.0
2009-08-06 12:00:00	SPY	ETF	100.08	100.09	99.73	99.85	20553137.0
2009-08-06 13:00:00	SPY	ETF	99.8501	100.22	99.78	99.82	15569877.0
2009-08-06 14:00:00	SPY	ETF	99.82	99.92	99.42	99.64	28720984.0
2009-08-06 15:00:00	SPY	ETF	99.64	100.07	99.6	99.88	30070075.0
2009-08-06 16:00:00	SPY	ETF	99.89	100.4571	99.7186	99.91	11806047.0
2009-08-06 17:00:00	SPY	ETF	99.9	99.9	99.84	99.85	213019.0
2009-08-06 18:00:00	SPY	ETF	99.85	99.93	99.82	99.85	58451.0
2009-08-06 19:00:00	SPY	ETF	99.85	99.94	99.85	99.92	100655.0
2009-08-06 04:00:00	QQQ	ETF	39.71	39.74	39.71	39.74	2859.0
2009-08-06 05:00:00	QQQ	ETF	39.63	39.71	39.63	39.67	1583.0
2009-08-06 06:00:00	QQQ	ETF	39.7	39.7	39.61	39.62	34100.0
2009-08-06 07:00:00	QQQ	ETF	39.59	39.8	39.59	39.76	581098.0
2009-08-06 08:00:00	QQQ	ETF	39.76	39.96	39.67	39.85	2642786.0
2009-08-06 09:00:00	QQQ	ETF	39.85	39.93	39.47	39.48	18466878.0
2009-08-06 10:00:00	QQQ	ETF	39.48	39.55	39.35	39.4501	22125765.0
2009-08-06 11:00:00	QQQ	ETF	39.4501	39.65	39.44	39.4401	14179389.0
2009-08-06 12:00:00	QQQ	ETF	39.45	39.5	39.31	39.399	9439495.0
2009-08-06 13:00:00	QQQ	ETF	39.4	39.57	39.36	39.41	5523301.0
2009-08-06 14:00:00	QQQ	ETF	39.41	39.42	39.24	39.34	13644523.0
2009-08-06 15:00:00	QQQ	ETF	39.33	39.47	39.31	39.4	20570805.0
2009-08-06 16:00:00	QQQ	ETF	39.4	39.7215	39.28	39.4	4028662.0
2009-08-06 17:00:00	QQQ	ETF	39.4	39.42	39.37	39.42	161916.0
2009-08-06 18:00:00	QQQ	ETF	39.4	39.41	39.37	39.39	73137.0
2009-08-06 19:00:00	QQQ	ETF	39.4	39.42	39.39	39.42	14667.0
2009-08-06 06:00:00	IWM	ETF	56.63	56.75	56.61	56.61	8450.0
2009-08-06 07:00:00	IWM	ETF	56.67	56.89	56.67	56.82	50222.0
2009-08-06 08:00:00	IWM	ETF	56.82	57.04	56.64	56.88	273751.0
2009-08-06 09:00:00	IWM	ETF	56.87	56.96	56.14	56.23	6477620.0
2009-08-06 10:00:00	IWM	ETF	56.22	56.27	55.66	56.08	8627945.0
2009-08-06 11:00:00	IWM	ETF	56.08	56.48	56.07	56.2398	5034189.0
2009-08-06 12:00:00	IWM	ETF	56.24	56.24	55.94	56.06	3584029.0
2009-08-06 13:00:00	IWM	ETF	56.06	56.29	55.92	55.97	2774195.0
2009-08-06 14:00:00	IWM	ETF	55.97	55.97	55.61	55.76	4031242.0
2009-08-06 15:00:00	IWM	ETF	55.76	56.07	55.7	55.77	9829602.0
2009-08-06 16:00:00	IWM	ETF	55.8	56.618	55.69	55.84	7782139.0
2009-08-06 17:00:00	IWM	ETF	55.84	55.86	55.8	55.82	55908.0
2009-08-06 18:00:00	IWM	ETF	55.8	55.85	55.73	55.8	7700.0
2009-08-06 19:00:00	IWM	ETF	55.85	55.88	55.76	55.88	5600.0
2009-08-06 05:00:00	DIA	ETF	92.9	92.9	92.9	92.9	100.0
2009-08-06 06:00:00	DIA	ETF	93.01	93.01	93.01	93.01	200.0
2009-08-06 07:00:00	DIA	ETF	93.07	93.36	93.04	93.3	13950.0
2009-08-06 08:00:00	DIA	ETF	93.28	93.55	93.27	93.35	61100.0

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

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