PREVIEW / etf_1hour / 2009-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-13.parquet
  size:    135 KB
  rows:    4,116

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-13 04:00:00	SPY	ETF	87.75	87.96	87.57	87.57	2100.0
2009-07-13 05:00:00	SPY	ETF	87.59	87.59	87.39	87.42	18100.0
2009-07-13 06:00:00	SPY	ETF	87.34	87.9	87.31	87.87	57300.0
2009-07-13 07:00:00	SPY	ETF	87.93	88.02	87.59	88.01	345552.0
2009-07-13 08:00:00	SPY	ETF	87.99	88.63	87.24	88.48	3260584.0
2009-07-13 09:00:00	SPY	ETF	88.47	88.6	87.96	88.01	19108344.0
2009-07-13 10:00:00	SPY	ETF	88.0	88.8	87.59	88.79	39695395.0
2009-07-13 11:00:00	SPY	ETF	88.79	89.59	88.65	89.43	31575817.0
2009-07-13 12:00:00	SPY	ETF	89.432	89.55	89.28	89.38	12341280.0
2009-07-13 13:00:00	SPY	ETF	89.38	89.75	89.35	89.6	20654317.0
2009-07-13 14:00:00	SPY	ETF	89.6	89.87	89.53	89.68	23272912.0
2009-07-13 15:00:00	SPY	ETF	89.67	90.17	89.64	90.12	50356484.0
2009-07-13 16:00:00	SPY	ETF	90.11	90.21	89.87	89.99	14847649.0
2009-07-13 17:00:00	SPY	ETF	89.97	90.21	89.95	90.2	1226653.0
2009-07-13 18:00:00	SPY	ETF	90.12	90.15	89.99	90.0	229051.0
2009-07-13 19:00:00	SPY	ETF	90.01	90.02	89.93	90.0	128262.0
2009-07-13 05:00:00	QQQ	ETF	34.72	34.72	34.72	34.72	20000.0
2009-07-13 06:00:00	QQQ	ETF	34.67	34.86	34.67	34.84	92600.0
2009-07-13 07:00:00	QQQ	ETF	34.89	34.94	34.76	34.94	124726.0
2009-07-13 08:00:00	QQQ	ETF	34.94	35.15	34.94	35.07	641701.0
2009-07-13 09:00:00	QQQ	ETF	35.07	35.09	34.52	34.63	21526612.0
2009-07-13 10:00:00	QQQ	ETF	34.62	35.13	34.48	35.13	21250797.0
2009-07-13 11:00:00	QQQ	ETF	35.13	35.49	35.06	35.41	21813331.0
2009-07-13 12:00:00	QQQ	ETF	35.42	35.45	35.32	35.33	7943520.0
2009-07-13 13:00:00	QQQ	ETF	35.33	35.5	35.3	35.4399	7714648.0
2009-07-13 14:00:00	QQQ	ETF	35.44	35.57	35.4	35.47	11068548.0
2009-07-13 15:00:00	QQQ	ETF	35.47	35.6	35.44	35.58	22711122.0
2009-07-13 16:00:00	QQQ	ETF	35.5701	35.63	35.49	35.52	8833794.0
2009-07-13 17:00:00	QQQ	ETF	35.5	35.54	35.49	35.52	215958.0
2009-07-13 18:00:00	QQQ	ETF	35.52	35.61	35.51	35.51	55202.0
2009-07-13 19:00:00	QQQ	ETF	35.51	35.53	35.5	35.53	19500.0
2009-07-13 06:00:00	IWM	ETF	48.05	48.11	48.05	48.11	4000.0
2009-07-13 07:00:00	IWM	ETF	48.0	48.18	47.97	48.18	42453.0
2009-07-13 08:00:00	IWM	ETF	48.11	48.59	47.6	48.46	310432.0
2009-07-13 09:00:00	IWM	ETF	48.47	48.5	47.62	47.66	4658645.0
2009-07-13 10:00:00	IWM	ETF	47.66	48.42	47.42	48.388	6343431.0
2009-07-13 11:00:00	IWM	ETF	48.38	48.9	48.23	48.81	7012230.0
2009-07-13 12:00:00	IWM	ETF	48.81	48.92	48.69	48.7201	2559506.0
2009-07-13 13:00:00	IWM	ETF	48.72	49.03	48.72	48.92	3404013.0
2009-07-13 14:00:00	IWM	ETF	48.94	49.14	48.905	48.99	4833029.0
2009-07-13 15:00:00	IWM	ETF	48.99	49.29	48.91	49.24	6796602.0
2009-07-13 16:00:00	IWM	ETF	49.23	49.36	47.8926	49.25	4207440.0
2009-07-13 17:00:00	IWM	ETF	49.23	49.35	49.22	49.32	30672.0
2009-07-13 18:00:00	IWM	ETF	49.35	49.35	49.24	49.24	600.0
2009-07-13 19:00:00	IWM	ETF	49.3	49.33	49.25	49.26	1600.0
2009-07-13 06:00:00	DIA	ETF	81.4	81.4	81.4	81.4	100.0
2009-07-13 07:00:00	DIA	ETF	81.23	81.5	81.23	81.5	2550.0
2009-07-13 08:00:00	DIA	ETF	81.45	82.0	81.45	81.9	85125.0
2009-07-13 09:00:00	DIA	ETF	81.9	82.06	81.64	81.66	1351074.0
2009-07-13 10:00:00	DIA	ETF	81.67	82.35	81.39	82.3406	2130673.0

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

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