PREVIEW / etf_1hour / 2009-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-29.parquet
  size:    138 KB
  rows:    4,234

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-07-29 04:00:00	SPY	ETF	97.58	97.86	97.58	97.66	2700.0
2009-07-29 05:00:00	SPY	ETF	97.66	97.76	97.4	97.4	111400.0
2009-07-29 06:00:00	SPY	ETF	97.47	97.81	97.47	97.67	98950.0
2009-07-29 07:00:00	SPY	ETF	97.75	97.75	97.43	97.43	745186.0
2009-07-29 08:00:00	SPY	ETF	97.43	97.84	97.14	97.37	6206519.0
2009-07-29 09:00:00	SPY	ETF	97.36	97.62	97.1	97.57	23097750.0
2009-07-29 10:00:00	SPY	ETF	97.57	97.93	97.35	97.55	34285371.0
2009-07-29 11:00:00	SPY	ETF	97.55	97.7	97.08	97.43	20727379.0
2009-07-29 12:00:00	SPY	ETF	97.43	97.68	97.37	97.56	13697099.0
2009-07-29 13:00:00	SPY	ETF	97.55	97.65	96.98	97.23	27452456.0
2009-07-29 14:00:00	SPY	ETF	97.24	97.47	97.01	97.04	18858986.0
2009-07-29 15:00:00	SPY	ETF	97.04	97.8	97.03	97.6583	34770995.0
2009-07-29 16:00:00	SPY	ETF	97.65	97.94	97.265	97.91	8314306.0
2009-07-29 17:00:00	SPY	ETF	97.9	98.05	97.24	98.01	501472.0
2009-07-29 18:00:00	SPY	ETF	98.0	98.0	97.88	97.9	100777.0
2009-07-29 19:00:00	SPY	ETF	97.88	97.95	97.81	97.93	71170.0
2009-07-29 04:00:00	QQQ	ETF	39.35	39.35	39.35	39.35	200.0
2009-07-29 05:00:00	QQQ	ETF	39.38	39.38	39.38	39.38	3000.0
2009-07-29 06:00:00	QQQ	ETF	39.35	39.44	39.35	39.43	8800.0
2009-07-29 07:00:00	QQQ	ETF	39.41	39.43	39.24	39.25	804016.0
2009-07-29 08:00:00	QQQ	ETF	39.25	39.38	39.11	39.22	1343182.0
2009-07-29 09:00:00	QQQ	ETF	39.22	39.37	39.0906	39.26	14899349.0
2009-07-29 10:00:00	QQQ	ETF	39.27	39.43	39.15	39.32	24447252.0
2009-07-29 11:00:00	QQQ	ETF	39.32	39.36	39.11	39.2504	16537312.0
2009-07-29 12:00:00	QQQ	ETF	39.25	39.37	39.2299	39.29	9536768.0
2009-07-29 13:00:00	QQQ	ETF	39.29	39.29	39.0	39.2021	21817733.0
2009-07-29 14:00:00	QQQ	ETF	39.21	39.31	39.13	39.14	7682444.0
2009-07-29 15:00:00	QQQ	ETF	39.14	39.41	39.14	39.35	18159645.0
2009-07-29 16:00:00	QQQ	ETF	39.35	39.44	39.2838	39.41	2737662.0
2009-07-29 17:00:00	QQQ	ETF	39.39	39.47	39.39	39.43	349831.0
2009-07-29 18:00:00	QQQ	ETF	39.43	39.47	39.41	39.44	147802.0
2009-07-29 19:00:00	QQQ	ETF	39.42	39.46	39.4	39.45	147097.0
2009-07-29 06:00:00	IWM	ETF	55.05	55.06	55.05	55.06	5000.0
2009-07-29 07:00:00	IWM	ETF	54.91	54.91	54.82	54.82	23000.0
2009-07-29 08:00:00	IWM	ETF	54.81	55.07	54.52	54.76	346290.0
2009-07-29 09:00:00	IWM	ETF	54.76	54.99	54.45	54.908	5341951.0
2009-07-29 10:00:00	IWM	ETF	54.91	55.13	54.8	54.89	6498187.0
2009-07-29 11:00:00	IWM	ETF	54.89	55.0	54.69	54.9	4854421.0
2009-07-29 12:00:00	IWM	ETF	54.89	55.06	54.83	55.02	2569127.0
2009-07-29 13:00:00	IWM	ETF	55.01	55.01	54.582	54.74	5361469.0
2009-07-29 14:00:00	IWM	ETF	54.75	54.87	54.61	54.62	3410528.0
2009-07-29 15:00:00	IWM	ETF	54.6206	55.01	54.62	54.88	9060957.0
2009-07-29 16:00:00	IWM	ETF	54.88	55.2036	54.82	54.95	6856089.0
2009-07-29 17:00:00	IWM	ETF	54.95	55.12	54.94	55.02	81200.0
2009-07-29 18:00:00	IWM	ETF	55.02	55.02	55.02	55.02	1875.0
2009-07-29 07:00:00	DIA	ETF	90.77	90.77	90.59	90.67	2700.0
2009-07-29 08:00:00	DIA	ETF	90.57	92.0	90.45	90.48	40473.0
2009-07-29 09:00:00	DIA	ETF	90.54	90.76	90.2699	90.71	1360737.0
2009-07-29 10:00:00	DIA	ETF	90.73	90.95	90.45	90.6299	1809630.0
2009-07-29 11:00:00	DIA	ETF	90.66	90.74	90.23	90.54	893338.0

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

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