PREVIEW / etf_1hour / 2009-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-30.parquet
  size:    146 KB
  rows:    4,454

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-30 04:00:00	SPY	ETF	106.2	106.45	106.2	106.45	12650.0
2009-09-30 05:00:00	SPY	ETF	106.54	106.54	106.41	106.42	9140.0
2009-09-30 06:00:00	SPY	ETF	106.47	106.47	106.32	106.34	28100.0
2009-09-30 07:00:00	SPY	ETF	106.34	106.46	106.25	106.39	279409.0
2009-09-30 08:00:00	SPY	ETF	106.29	106.77	105.94	106.38	2969142.0
2009-09-30 09:00:00	SPY	ETF	106.38	106.46	104.62	104.81	45091271.0
2009-09-30 10:00:00	SPY	ETF	104.81	106.25	104.66	104.899	29963493.0
2009-09-30 11:00:00	SPY	ETF	104.9	105.44	104.88	105.32	19731274.0
2009-09-30 12:00:00	SPY	ETF	105.32	106.02	105.23	105.92	24888210.0
2009-09-30 13:00:00	SPY	ETF	105.91	106.38	105.91	106.03	23004993.0
2009-09-30 14:00:00	SPY	ETF	106.0399	106.25	105.72	105.74	17114650.0
2009-09-30 15:00:00	SPY	ETF	105.73	105.9	105.15	105.59	57731126.0
2009-09-30 16:00:00	SPY	ETF	105.61	106.24	104.69	105.7	25730864.0
2009-09-30 17:00:00	SPY	ETF	105.69	105.72	105.64	105.65	337807.0
2009-09-30 18:00:00	SPY	ETF	105.67	105.82	105.56	105.82	288088.0
2009-09-30 19:00:00	SPY	ETF	105.82	105.9	105.79	105.9	61766.0
2009-09-30 06:00:00	QQQ	ETF	42.42	42.43	42.4	42.42	25600.0
2009-09-30 07:00:00	QQQ	ETF	42.38	42.43	42.37	42.43	105334.0
2009-09-30 08:00:00	QQQ	ETF	42.4	42.51	42.28	42.44	1013492.0
2009-09-30 09:00:00	QQQ	ETF	42.43	42.49	41.6	41.75	28395172.0
2009-09-30 10:00:00	QQQ	ETF	41.74	41.87	41.68	41.8001	21812194.0
2009-09-30 11:00:00	QQQ	ETF	41.8001	42.12	41.79	42.07	12073604.0
2009-09-30 12:00:00	QQQ	ETF	42.08	42.49	42.01	42.41	21463762.0
2009-09-30 13:00:00	QQQ	ETF	42.42	42.6024	42.36	42.42	18267299.0
2009-09-30 14:00:00	QQQ	ETF	42.4101	42.48	42.26	42.26	12494010.0
2009-09-30 15:00:00	QQQ	ETF	42.2699	42.35	42.055	42.23	39560718.0
2009-09-30 16:00:00	QQQ	ETF	42.23	42.29	42.12	42.2	7989971.0
2009-09-30 17:00:00	QQQ	ETF	42.21	42.22	42.18	42.21	27130.0
2009-09-30 18:00:00	QQQ	ETF	42.2	42.27	42.16	42.27	1061269.0
2009-09-30 19:00:00	QQQ	ETF	42.24	42.33	42.23	42.32	43039.0
2009-09-30 07:00:00	IWM	ETF	61.14	61.18	61.11	61.18	13000.0
2009-09-30 08:00:00	IWM	ETF	61.19	61.38	61.01	61.19	1872093.0
2009-09-30 09:00:00	IWM	ETF	61.18	61.2	59.56	59.75	12005008.0
2009-09-30 10:00:00	IWM	ETF	59.75	59.99	59.64	59.8999	10734709.0
2009-09-30 11:00:00	IWM	ETF	59.89	60.25	59.88	60.17	8045696.0
2009-09-30 12:00:00	IWM	ETF	60.18	60.88	60.13	60.82	8269012.0
2009-09-30 13:00:00	IWM	ETF	60.82	61.24	60.76	60.86	7724661.0
2009-09-30 14:00:00	IWM	ETF	60.87	61.03	60.6	60.61	4093978.0
2009-09-30 15:00:00	IWM	ETF	60.61	60.61	60.2	60.32	16858013.0
2009-09-30 16:00:00	IWM	ETF	60.32	61.0441	60.2	60.32	5760558.0
2009-09-30 17:00:00	IWM	ETF	60.33	60.5	60.31	60.37	304725.0
2009-09-30 18:00:00	IWM	ETF	60.34	60.43	60.33	60.43	3200.0
2009-09-30 19:00:00	IWM	ETF	60.44	60.44	60.42	60.42	200.0
2009-09-30 06:00:00	DIA	ETF	97.65	97.65	97.65	97.65	100.0
2009-09-30 07:00:00	DIA	ETF	97.72	97.72	97.72	97.72	400.0
2009-09-30 08:00:00	DIA	ETF	97.66	98.36	97.5	97.72	140021.0
2009-09-30 09:00:00	DIA	ETF	97.73	97.73	96.07	96.19	2759340.0
2009-09-30 10:00:00	DIA	ETF	96.17	96.45	96.09	96.38	2305765.0
2009-09-30 11:00:00	DIA	ETF	96.38	96.84	96.38	96.75	942998.0
2009-09-30 12:00:00	DIA	ETF	96.75	97.36	96.67	97.28	1589026.0

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

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