PREVIEW / etf_1hour / 2009-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-09.parquet
  size:    134 KB
  rows:    4,105

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-04-09 04:00:00	SPY	ETF	83.22	83.22	83.14	83.14	1500.0
2009-04-09 05:00:00	SPY	ETF	83.33	83.5	83.3	83.5	47750.0
2009-04-09 06:00:00	SPY	ETF	83.45	83.45	83.23	83.27	26100.0
2009-04-09 07:00:00	SPY	ETF	83.26	83.31	83.0	83.1	553838.0
2009-04-09 08:00:00	SPY	ETF	83.09	84.83	83.09	84.61	11824620.0
2009-04-09 09:00:00	SPY	ETF	84.61	85.09	82.49	85.05	43427090.0
2009-04-09 10:00:00	SPY	ETF	85.05	85.19	84.69	84.8	44290094.0
2009-04-09 11:00:00	SPY	ETF	84.8	84.94	84.43	84.72	25616010.0
2009-04-09 12:00:00	SPY	ETF	84.72	84.9	84.54	84.77	22981567.0
2009-04-09 13:00:00	SPY	ETF	84.78	85.1	84.66	85.0601	17759399.0
2009-04-09 14:00:00	SPY	ETF	85.07	85.49	84.73	85.31	32438270.0
2009-04-09 15:00:00	SPY	ETF	85.31	85.82	84.95	85.82	56163395.0
2009-04-09 16:00:00	SPY	ETF	85.81	85.94	85.55	85.86	13655564.0
2009-04-09 17:00:00	SPY	ETF	85.87	85.88	85.5	85.63	395984.0
2009-04-09 18:00:00	SPY	ETF	85.63	85.65	85.57	85.59	79969.0
2009-04-09 19:00:00	SPY	ETF	85.58	85.68	85.56	85.64	35230.0
2009-04-09 04:00:00	QQQ	ETF	32.19	32.19	32.1	32.1	4000.0
2009-04-09 06:00:00	QQQ	ETF	32.25	32.25	32.2	32.2	12200.0
2009-04-09 07:00:00	QQQ	ETF	32.19	32.23	31.98	32.12	518320.0
2009-04-09 08:00:00	QQQ	ETF	32.11	32.57	32.11	32.52	3642896.0
2009-04-09 09:00:00	QQQ	ETF	32.52	32.95	32.43	32.91	23658753.0
2009-04-09 10:00:00	QQQ	ETF	32.91	32.99	32.77	32.78	19086874.0
2009-04-09 11:00:00	QQQ	ETF	32.7812	32.88	32.7	32.85	11660445.0
2009-04-09 12:00:00	QQQ	ETF	32.86	32.89	32.77	32.85	9171793.0
2009-04-09 13:00:00	QQQ	ETF	32.85	32.96	32.84	32.94	8890909.0
2009-04-09 14:00:00	QQQ	ETF	32.9401	33.01	32.84	32.95	17732053.0
2009-04-09 15:00:00	QQQ	ETF	32.96	32.99	32.81	32.94	23010247.0
2009-04-09 16:00:00	QQQ	ETF	32.95	33.0	32.82	32.88	5924179.0
2009-04-09 17:00:00	QQQ	ETF	32.87	32.92	32.86	32.9	4004213.0
2009-04-09 18:00:00	QQQ	ETF	32.9	32.92	32.86	32.86	20300.0
2009-04-09 19:00:00	QQQ	ETF	32.91	32.95	32.9	32.94	11280.0
2009-04-09 06:00:00	IWM	ETF	44.3	44.3	44.3	44.3	450.0
2009-04-09 07:00:00	IWM	ETF	44.24	44.28	44.23	44.25	1900.0
2009-04-09 08:00:00	IWM	ETF	44.22	45.31	44.22	45.27	1168244.0
2009-04-09 09:00:00	IWM	ETF	45.24	45.92	45.1	45.9	7051346.0
2009-04-09 10:00:00	IWM	ETF	45.9	46.13	45.9	45.97	10940091.0
2009-04-09 11:00:00	IWM	ETF	45.98	46.17	45.93	46.05	4805448.0
2009-04-09 12:00:00	IWM	ETF	46.05	46.2	46.01	46.16	4884213.0
2009-04-09 13:00:00	IWM	ETF	46.16	46.41	46.14	46.4	5381987.0
2009-04-09 14:00:00	IWM	ETF	46.4	46.61	46.25	46.53	7126021.0
2009-04-09 15:00:00	IWM	ETF	46.52	46.71	46.2833	46.62	12406218.0
2009-04-09 16:00:00	IWM	ETF	46.62	46.99	44.198	46.55	7853265.0
2009-04-09 17:00:00	IWM	ETF	46.6	46.6	45.4389	45.4389	12617.0
2009-04-09 18:00:00	IWM	ETF	46.6	46.6	46.6	46.6	120.0
2009-04-09 19:00:00	IWM	ETF	46.6	46.61	46.6	46.61	2571.0
2009-04-09 06:00:00	DIA	ETF	79.08	79.08	79.02	79.07	694.0
2009-04-09 07:00:00	DIA	ETF	79.09	79.11	78.89	78.98	15482.0
2009-04-09 08:00:00	DIA	ETF	78.93	80.13	78.93	79.96	290473.0
2009-04-09 09:00:00	DIA	ETF	79.98	80.43	79.7601	80.3878	2799381.0
2009-04-09 10:00:00	DIA	ETF	80.39	80.54	80.14	80.24	2966040.0

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

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