PREVIEW / etf_1hour / 2009-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-07.parquet
  size:    143 KB
  rows:    4,388

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-07 04:00:00	SPY	ETF	99.55	99.67	99.5	99.54	2750.0
2009-08-07 05:00:00	SPY	ETF	99.62	99.75	99.6	99.6	5800.0
2009-08-07 06:00:00	SPY	ETF	99.5	99.6	99.45	99.55	20300.0
2009-08-07 07:00:00	SPY	ETF	99.57	99.87	99.56	99.8	679474.0
2009-08-07 08:00:00	SPY	ETF	99.79	100.93	99.72	100.74	13140905.0
2009-08-07 09:00:00	SPY	ETF	100.73	101.19	100.63	100.63	32144684.0
2009-08-07 10:00:00	SPY	ETF	100.63	101.63	100.39	101.53	52587402.0
2009-08-07 11:00:00	SPY	ETF	101.53	101.75	101.27	101.51	24631003.0
2009-08-07 12:00:00	SPY	ETF	101.51	101.74	101.35	101.6375	15406904.0
2009-08-07 13:00:00	SPY	ETF	101.64	102.03	101.0	101.8399	17366074.0
2009-08-07 14:00:00	SPY	ETF	101.84	101.92	101.62	101.64	12939270.0
2009-08-07 15:00:00	SPY	ETF	101.64	101.65	101.19	101.19	39065582.0
2009-08-07 16:00:00	SPY	ETF	101.18	101.84	100.5048	100.9	10424277.0
2009-08-07 17:00:00	SPY	ETF	100.9	100.95	100.82	100.94	255793.0
2009-08-07 18:00:00	SPY	ETF	100.93	101.04	100.92	100.97	25833.0
2009-08-07 19:00:00	SPY	ETF	100.97	101.09	100.93	101.09	25073.0
2009-08-07 04:00:00	QQQ	ETF	39.32	39.35	39.32	39.33	895.0
2009-08-07 06:00:00	QQQ	ETF	39.31	39.31	39.31	39.31	1000.0
2009-08-07 07:00:00	QQQ	ETF	39.37	39.46	39.32	39.41	265694.0
2009-08-07 08:00:00	QQQ	ETF	39.41	39.93	39.38	39.85	3098343.0
2009-08-07 09:00:00	QQQ	ETF	39.86	40.03	39.72	39.72	20640784.0
2009-08-07 10:00:00	QQQ	ETF	39.72	40.0	39.59	39.95	20678154.0
2009-08-07 11:00:00	QQQ	ETF	39.96	40.07	39.89	39.97	12294764.0
2009-08-07 12:00:00	QQQ	ETF	39.97	40.02	39.8844	39.98	6577863.0
2009-08-07 13:00:00	QQQ	ETF	39.98	40.07	39.96	40.03	8513469.0
2009-08-07 14:00:00	QQQ	ETF	40.02	40.0599	39.94	39.9401	4931535.0
2009-08-07 15:00:00	QQQ	ETF	39.94	39.96	39.81	39.87	17333332.0
2009-08-07 16:00:00	QQQ	ETF	39.87	40.04	39.3728	39.76	8121399.0
2009-08-07 17:00:00	QQQ	ETF	39.76	39.85	39.74	39.85	88807.0
2009-08-07 18:00:00	QQQ	ETF	39.8	39.84	39.77	39.8	40831.0
2009-08-07 19:00:00	QQQ	ETF	39.82	39.82	39.77	39.79	52800.0
2009-08-07 07:00:00	IWM	ETF	55.7	55.79	55.62	55.78	19049.0
2009-08-07 08:00:00	IWM	ETF	55.8	56.62	55.46	56.44	1086463.0
2009-08-07 09:00:00	IWM	ETF	56.44	56.99	56.32	56.55	7100633.0
2009-08-07 10:00:00	IWM	ETF	56.54	57.24	56.29	57.14	7897270.0
2009-08-07 11:00:00	IWM	ETF	57.14	57.49	57.1	57.37	5125736.0
2009-08-07 12:00:00	IWM	ETF	57.38	57.58	57.25	57.52	2145455.0
2009-08-07 13:00:00	IWM	ETF	57.52	57.84	57.52	57.69	3685653.0
2009-08-07 14:00:00	IWM	ETF	57.7	57.79	57.48	57.49	2979677.0
2009-08-07 15:00:00	IWM	ETF	57.49	57.51	57.16	57.2	8531137.0
2009-08-07 16:00:00	IWM	ETF	57.19	57.19	56.8636	57.0	2732266.0
2009-08-07 17:00:00	IWM	ETF	57.0	57.08	57.0	57.08	1800.0
2009-08-07 18:00:00	IWM	ETF	57.09	57.15	57.01	57.13	1700.0
2009-08-07 19:00:00	IWM	ETF	57.16	57.16	57.16	57.16	400.0
2009-08-07 07:00:00	DIA	ETF	92.5	92.62	92.42	92.61	1900.0
2009-08-07 08:00:00	DIA	ETF	92.61	93.47	92.45	93.33	172402.0
2009-08-07 09:00:00	DIA	ETF	93.35	93.73	93.26	93.282	1877677.0
2009-08-07 10:00:00	DIA	ETF	93.27	94.2	93.11	94.09	2773083.0
2009-08-07 11:00:00	DIA	ETF	94.11	94.3	93.85	94.02	1698319.0
2009-08-07 12:00:00	DIA	ETF	94.02	94.22	93.9299	94.14	886493.0

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

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