PREVIEW / etf_1hour / 2009-08-25

all etf 1-hour files

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

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-25 04:00:00	SPY	ETF	102.97	102.97	102.87	102.93	1600.0
2009-08-25 05:00:00	SPY	ETF	103.08	103.14	103.08	103.09	8300.0
2009-08-25 06:00:00	SPY	ETF	103.09	103.11	102.99	103.04	18480.0
2009-08-25 07:00:00	SPY	ETF	103.05	103.48	103.0	103.48	828247.0
2009-08-25 08:00:00	SPY	ETF	103.48	103.59	102.65	103.51	3076512.0
2009-08-25 09:00:00	SPY	ETF	103.52	103.79	102.36	103.68	23415155.0
2009-08-25 10:00:00	SPY	ETF	103.69	104.26	103.12	103.51	52248861.0
2009-08-25 11:00:00	SPY	ETF	103.5	103.86	103.47	103.72	16274055.0
2009-08-25 12:00:00	SPY	ETF	103.72	104.03	103.54	103.56	22923738.0
2009-08-25 13:00:00	SPY	ETF	103.562	103.67	103.18	103.25	21522501.0
2009-08-25 14:00:00	SPY	ETF	103.25	103.44	102.94	103.22	26501258.0
2009-08-25 15:00:00	SPY	ETF	103.23	103.5	103.03	103.16	30373563.0
2009-08-25 16:00:00	SPY	ETF	103.16	103.8652	103.0	103.05	14128379.0
2009-08-25 17:00:00	SPY	ETF	103.05	103.4849	102.99	103.01	772113.0
2009-08-25 18:00:00	SPY	ETF	103.0	103.14	102.9	102.92	312049.0
2009-08-25 19:00:00	SPY	ETF	102.92	102.92	102.69	102.73	256897.0
2009-08-25 05:00:00	QQQ	ETF	40.26	40.31	40.26	40.27	1404.0
2009-08-25 06:00:00	QQQ	ETF	40.29	40.29	40.24	40.24	1563.0
2009-08-25 07:00:00	QQQ	ETF	40.25	40.43	40.25	40.41	81067.0
2009-08-25 08:00:00	QQQ	ETF	40.4	40.45	39.975	40.43	1114224.0
2009-08-25 09:00:00	QQQ	ETF	40.42	40.61	40.26	40.61	12693882.0
2009-08-25 10:00:00	QQQ	ETF	40.54	40.76	40.34	40.48	27017103.0
2009-08-25 11:00:00	QQQ	ETF	40.48	40.62	40.46	40.57	5220729.0
2009-08-25 12:00:00	QQQ	ETF	40.58	40.6801	40.46	40.48	9179168.0
2009-08-25 13:00:00	QQQ	ETF	40.47	40.6167	40.34	40.3778	8523366.0
2009-08-25 14:00:00	QQQ	ETF	40.38	40.435	40.25	40.352	9187430.0
2009-08-25 15:00:00	QQQ	ETF	40.3779	40.47	40.3	40.36	12730092.0
2009-08-25 16:00:00	QQQ	ETF	40.36	40.64	40.28	40.31	4698542.0
2009-08-25 17:00:00	QQQ	ETF	40.31	40.33	40.28	40.32	70943.0
2009-08-25 18:00:00	QQQ	ETF	40.31	40.31	40.28	40.28	46465.0
2009-08-25 19:00:00	QQQ	ETF	40.29	40.29	40.22	40.22	26137.0
2009-08-25 07:00:00	IWM	ETF	58.27	58.47	58.26	58.46	29469.0
2009-08-25 08:00:00	IWM	ETF	58.44	58.55	58.18	58.5	247163.0
2009-08-25 09:00:00	IWM	ETF	58.5	58.71	58.2	58.63	3825648.0
2009-08-25 10:00:00	IWM	ETF	58.62	59.07	58.21	58.48	6779295.0
2009-08-25 11:00:00	IWM	ETF	58.4807	58.66	58.44	58.6	2180490.0
2009-08-25 12:00:00	IWM	ETF	58.61	58.85	58.56	58.58	2166908.0
2009-08-25 13:00:00	IWM	ETF	58.58	58.66	58.4	58.45	3750510.0
2009-08-25 14:00:00	IWM	ETF	58.45	58.59	58.27	58.47	3885059.0
2009-08-25 15:00:00	IWM	ETF	58.47	58.58	58.31	58.3401	5041670.0
2009-08-25 16:00:00	IWM	ETF	58.36	58.6905	58.28	58.31	666646.0
2009-08-25 17:00:00	IWM	ETF	58.29	58.32	58.29	58.31	3600.0
2009-08-25 18:00:00	IWM	ETF	58.33	58.33	58.31	58.31	500.0
2009-08-25 19:00:00	IWM	ETF	58.31	58.38	58.2	58.27	9557.0
2009-08-25 06:00:00	DIA	ETF	95.11	95.11	95.11	95.11	100.0
2009-08-25 07:00:00	DIA	ETF	95.22	95.55	95.22	95.55	900.0
2009-08-25 08:00:00	DIA	ETF	95.55	95.63	95.48	95.55	39522.0
2009-08-25 09:00:00	DIA	ETF	95.57	96.01	95.28	95.85	1310222.0
2009-08-25 10:00:00	DIA	ETF	95.88	96.82	95.4	95.72	3922554.0
2009-08-25 11:00:00	DIA	ETF	95.72	96.01	95.69	95.9085	1342253.0

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

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