PREVIEW / etf_1hour / 2009-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-16.parquet
  size:    149 KB
  rows:    4,603

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-09-16 04:00:00	SPY	ETF	105.9	105.97	105.88	105.93	2700.0
2009-09-16 05:00:00	SPY	ETF	105.91	106.05	105.87	106.04	36900.0
2009-09-16 06:00:00	SPY	ETF	106.01	106.11	105.95	106.07	148858.0
2009-09-16 07:00:00	SPY	ETF	106.04	106.15	105.91	106.06	367666.0
2009-09-16 08:00:00	SPY	ETF	106.05	106.1	105.74	106.06	3057419.0
2009-09-16 09:00:00	SPY	ETF	106.06	106.29	105.73	105.94	26796252.0
2009-09-16 10:00:00	SPY	ETF	105.93	106.48	105.93	106.4	31417051.0
2009-09-16 11:00:00	SPY	ETF	106.41	106.79	106.28	106.78	23425132.0
2009-09-16 12:00:00	SPY	ETF	106.78	106.99	106.75	106.79	19450790.0
2009-09-16 13:00:00	SPY	ETF	106.79	107.27	106.78	107.12	22220374.0
2009-09-16 14:00:00	SPY	ETF	107.12	107.31	106.97	106.98	26298785.0
2009-09-16 15:00:00	SPY	ETF	106.98	107.34	106.91	107.31	37936158.0
2009-09-16 16:00:00	SPY	ETF	107.3	107.345	106.14	107.26	9645088.0
2009-09-16 17:00:00	SPY	ETF	107.27	107.39	105.9694	106.43	353592.0
2009-09-16 18:00:00	SPY	ETF	107.33	107.33	105.75	107.22	284345.0
2009-09-16 19:00:00	SPY	ETF	107.22	107.4	105.9	107.35	69619.0
2009-09-16 04:00:00	QQQ	ETF	41.89	41.92	41.89	41.92	2000.0
2009-09-16 05:00:00	QQQ	ETF	41.94	41.96	41.92	41.92	15000.0
2009-09-16 06:00:00	QQQ	ETF	41.88	41.94	41.87	41.93	10804.0
2009-09-16 07:00:00	QQQ	ETF	41.94	41.98	41.86	41.94	96373.0
2009-09-16 08:00:00	QQQ	ETF	41.94	41.98	41.87	41.96	828688.0
2009-09-16 09:00:00	QQQ	ETF	41.96	42.05	41.84	41.94	11171343.0
2009-09-16 10:00:00	QQQ	ETF	41.94	42.07	41.89	42.04	12759040.0
2009-09-16 11:00:00	QQQ	ETF	42.05	42.21	41.98	42.1999	9111600.0
2009-09-16 12:00:00	QQQ	ETF	42.2	42.41	42.18	42.23	10604754.0
2009-09-16 13:00:00	QQQ	ETF	42.22	42.44	42.22	42.39	10917919.0
2009-09-16 14:00:00	QQQ	ETF	42.39	42.48	42.34	42.34	8009478.0
2009-09-16 15:00:00	QQQ	ETF	42.34	42.45	42.32	42.41	12120386.0
2009-09-16 16:00:00	QQQ	ETF	42.42	42.42	41.8493	42.3	9156603.0
2009-09-16 17:00:00	QQQ	ETF	42.445	42.445	42.31	42.35	6994645.0
2009-09-16 18:00:00	QQQ	ETF	42.35	42.44	42.32	42.32	38454.0
2009-09-16 19:00:00	QQQ	ETF	42.32	42.38	42.32	42.37	25636.0
2009-09-16 06:00:00	IWM	ETF	60.75	60.75	60.75	60.75	100.0
2009-09-16 07:00:00	IWM	ETF	60.8	60.8	60.7	60.73	7100.0
2009-09-16 08:00:00	IWM	ETF	60.75	60.85	60.67	60.83	466103.0
2009-09-16 09:00:00	IWM	ETF	60.84	60.99	60.62	60.82	4749129.0
2009-09-16 10:00:00	IWM	ETF	60.83	61.16	60.79	61.09	4908965.0
2009-09-16 11:00:00	IWM	ETF	61.09	61.43	61.04	61.41	4198591.0
2009-09-16 12:00:00	IWM	ETF	61.41	61.61	61.4	61.43	3914386.0
2009-09-16 13:00:00	IWM	ETF	61.43	61.74	61.42	61.609	3091867.0
2009-09-16 14:00:00	IWM	ETF	61.61	61.7674	61.6	61.6	3490191.0
2009-09-16 15:00:00	IWM	ETF	61.6	61.8	61.1	61.8	8009086.0
2009-09-16 16:00:00	IWM	ETF	61.8	61.8272	60.5932	61.76	3747736.0
2009-09-16 17:00:00	IWM	ETF	61.78	61.82	60.92	61.05	6152.0
2009-09-16 18:00:00	IWM	ETF	61.1006	61.83	60.63	60.8199	3800.0
2009-09-16 19:00:00	IWM	ETF	61.82	61.82	60.87	61.8	5000.0
2009-09-16 07:00:00	DIA	ETF	97.28	97.29	97.27	97.27	2300.0
2009-09-16 08:00:00	DIA	ETF	97.3	97.3	97.15	97.29	30341.0
2009-09-16 09:00:00	DIA	ETF	97.27	97.48	96.94	97.0998	1392118.0
2009-09-16 10:00:00	DIA	ETF	97.1	97.42	97.03	97.37	1637684.0

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

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