PREVIEW / etf_1hour / 2009-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-30.parquet
  size:    134 KB
  rows:    4,142

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-06-30 04:00:00	SPY	ETF	92.75	92.75	92.73	92.73	3100.0
2009-06-30 05:00:00	SPY	ETF	92.83	92.93	92.83	92.93	7000.0
2009-06-30 06:00:00	SPY	ETF	92.92	92.92	92.83	92.87	1900.0
2009-06-30 07:00:00	SPY	ETF	92.87	92.88	92.68	92.71	162775.0
2009-06-30 08:00:00	SPY	ETF	92.71	92.84	92.64	92.83	629088.0
2009-06-30 09:00:00	SPY	ETF	92.84	93.06	92.65	92.87	20026303.0
2009-06-30 10:00:00	SPY	ETF	92.9	92.91	91.52	91.74	55325414.0
2009-06-30 11:00:00	SPY	ETF	91.7483	91.82	91.27	91.48	27539066.0
2009-06-30 12:00:00	SPY	ETF	91.47	91.72	91.38	91.6683	13318958.0
2009-06-30 13:00:00	SPY	ETF	91.67	91.67	91.39	91.45	14313724.0
2009-06-30 14:00:00	SPY	ETF	91.45	91.83	91.37	91.7001	17580249.0
2009-06-30 15:00:00	SPY	ETF	91.7	92.085	91.58	92.03	43024298.0
2009-06-30 16:00:00	SPY	ETF	92.04	92.7408	91.38	92.03	21638396.0
2009-06-30 17:00:00	SPY	ETF	92.02	92.02	91.96	91.98	1861206.0
2009-06-30 18:00:00	SPY	ETF	91.98	91.99	91.9	91.9	55763.0
2009-06-30 19:00:00	SPY	ETF	91.88	91.96	91.88	91.92	25520.0
2009-06-30 04:00:00	QQQ	ETF	36.56	36.58	36.56	36.58	715.0
2009-06-30 05:00:00	QQQ	ETF	36.54	36.6	36.54	36.6	7600.0
2009-06-30 06:00:00	QQQ	ETF	36.56	36.58	36.55	36.56	1000.0
2009-06-30 07:00:00	QQQ	ETF	36.58	36.58	36.51	36.54	56414.0
2009-06-30 08:00:00	QQQ	ETF	36.54	36.57	36.49	36.55	563438.0
2009-06-30 09:00:00	QQQ	ETF	36.56	36.73	36.5	36.65	10244346.0
2009-06-30 10:00:00	QQQ	ETF	36.65	36.67	36.18	36.3501	22857667.0
2009-06-30 11:00:00	QQQ	ETF	36.36	36.38	36.19	36.23	9746109.0
2009-06-30 12:00:00	QQQ	ETF	36.2299	36.29	36.14	36.23	8751605.0
2009-06-30 13:00:00	QQQ	ETF	36.2295	36.25	36.15	36.16	6838654.0
2009-06-30 14:00:00	QQQ	ETF	36.1699	36.3441	36.11	36.23	9751899.0
2009-06-30 15:00:00	QQQ	ETF	36.24	36.41	36.19	36.36	21323514.0
2009-06-30 16:00:00	QQQ	ETF	36.36	36.496	36.15	36.35	3652332.0
2009-06-30 17:00:00	QQQ	ETF	36.35	36.37	36.31	36.34	65653.0
2009-06-30 18:00:00	QQQ	ETF	36.35	36.35	36.31	36.32	66184.0
2009-06-30 19:00:00	QQQ	ETF	36.32	36.35	36.31	36.32	13800.0
2009-06-30 07:00:00	IWM	ETF	51.32	51.32	51.2	51.23	20669.0
2009-06-30 08:00:00	IWM	ETF	51.23	51.37	51.21	51.37	363689.0
2009-06-30 09:00:00	IWM	ETF	51.36	51.6101	51.2	51.48	5535509.0
2009-06-30 10:00:00	IWM	ETF	51.54	51.56	50.77	50.97	7577471.0
2009-06-30 11:00:00	IWM	ETF	50.98	51.13	50.8	50.96	3840828.0
2009-06-30 12:00:00	IWM	ETF	50.97	51.15	50.86	51.049	2139536.0
2009-06-30 13:00:00	IWM	ETF	51.0499	51.06	50.92	50.95	2322165.0
2009-06-30 14:00:00	IWM	ETF	50.94	51.14	50.89	51.08	2790178.0
2009-06-30 15:00:00	IWM	ETF	51.08	51.29	50.91	50.98	12800742.0
2009-06-30 16:00:00	IWM	ETF	50.97	51.18	50.954	51.01	5742174.0
2009-06-30 17:00:00	IWM	ETF	51.02	51.03	51.02	51.03	1000.0
2009-06-30 18:00:00	IWM	ETF	50.96	50.97	50.95	50.97	1000.0
2009-06-30 19:00:00	IWM	ETF	51.01	51.01	51.01	51.01	100.0
2009-06-30 07:00:00	DIA	ETF	85.27	85.31	85.27	85.31	3400.0
2009-06-30 08:00:00	DIA	ETF	85.26	85.42	85.26	85.42	7900.0
2009-06-30 09:00:00	DIA	ETF	85.49	85.64	85.25	85.51	1152967.0
2009-06-30 10:00:00	DIA	ETF	85.5	85.51	84.2	84.371	4596951.0
2009-06-30 11:00:00	DIA	ETF	84.38	84.43	83.96	84.1	1303683.0

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

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