PREVIEW / etf_1hour / 2009-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-11.parquet
  size:    139 KB
  rows:    4,280

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-11 04:00:00	SPY	ETF	101.44	101.48	101.44	101.48	2081.0
2009-08-11 05:00:00	SPY	ETF	101.4	101.4	101.2	101.2	3800.0
2009-08-11 06:00:00	SPY	ETF	101.2	101.2	100.93	101.05	29200.0
2009-08-11 07:00:00	SPY	ETF	101.02	101.14	100.8	100.84	622452.0
2009-08-11 08:00:00	SPY	ETF	100.83	101.16	100.7	100.76	2877225.0
2009-08-11 09:00:00	SPY	ETF	100.75	100.75	100.07	100.26	22488648.0
2009-08-11 10:00:00	SPY	ETF	100.25	100.46	99.69	99.8717	26124903.0
2009-08-11 11:00:00	SPY	ETF	99.87	100.42	99.46	99.67	19461892.0
2009-08-11 12:00:00	SPY	ETF	99.67	99.82	99.46	99.5	10370752.0
2009-08-11 13:00:00	SPY	ETF	99.49	100.475	99.47	99.7201	11559105.0
2009-08-11 14:00:00	SPY	ETF	99.72	100.02	99.72	99.99	21899887.0
2009-08-11 15:00:00	SPY	ETF	99.99	100.12	99.63	99.66	27946235.0
2009-08-11 16:00:00	SPY	ETF	99.66	99.8	99.55	99.75	12105131.0
2009-08-11 17:00:00	SPY	ETF	99.75	100.928	99.63	99.67	1074528.0
2009-08-11 18:00:00	SPY	ETF	99.69	99.75	99.66	99.72	39709.0
2009-08-11 19:00:00	SPY	ETF	99.72	99.75	99.7	99.74	7938.0
2009-08-11 04:00:00	QQQ	ETF	39.8	39.8	39.79	39.79	1567.0
2009-08-11 05:00:00	QQQ	ETF	39.8	39.8	39.8	39.8	5000.0
2009-08-11 06:00:00	QQQ	ETF	39.68	39.68	39.62	39.62	600.0
2009-08-11 07:00:00	QQQ	ETF	39.67	39.7	39.6	39.61	215311.0
2009-08-11 08:00:00	QQQ	ETF	39.61	39.77	39.51	39.52	1748251.0
2009-08-11 09:00:00	QQQ	ETF	39.51	39.51	39.26	39.36	17976945.0
2009-08-11 10:00:00	QQQ	ETF	39.36	39.365	39.07	39.13	20301873.0
2009-08-11 11:00:00	QQQ	ETF	39.12	39.18	39.05	39.1499	7824900.0
2009-08-11 12:00:00	QQQ	ETF	39.14	39.2	39.08	39.081	6068452.0
2009-08-11 13:00:00	QQQ	ETF	39.08	39.2	39.07	39.1622	4724756.0
2009-08-11 14:00:00	QQQ	ETF	39.17	39.33	39.165	39.33	11719698.0
2009-08-11 15:00:00	QQQ	ETF	39.32	39.42	39.23	39.25	15614190.0
2009-08-11 16:00:00	QQQ	ETF	39.25	39.3925	39.09	39.32	4405342.0
2009-08-11 17:00:00	QQQ	ETF	39.32	39.32	39.27	39.29	17529.0
2009-08-11 18:00:00	QQQ	ETF	39.27	39.33	39.23	39.31	50309.0
2009-08-11 19:00:00	QQQ	ETF	39.3	39.31	39.26	39.3	13325.0
2009-08-11 06:00:00	IWM	ETF	57.19	57.19	57.19	57.19	200.0
2009-08-11 07:00:00	IWM	ETF	57.2	57.22	57.08	57.08	15300.0
2009-08-11 08:00:00	IWM	ETF	57.09	57.27	57.06	57.08	642204.0
2009-08-11 09:00:00	IWM	ETF	57.08	57.17	56.4	56.55	7540270.0
2009-08-11 10:00:00	IWM	ETF	56.55	56.55	56.08	56.25	6503563.0
2009-08-11 11:00:00	IWM	ETF	56.25	56.291	56.01	56.229	4249020.0
2009-08-11 12:00:00	IWM	ETF	56.2294	56.342	56.0	56.05	1548623.0
2009-08-11 13:00:00	IWM	ETF	56.05	56.305	55.98	56.2025	2538634.0
2009-08-11 14:00:00	IWM	ETF	56.21	56.3901	56.205	56.39	3372841.0
2009-08-11 15:00:00	IWM	ETF	56.39	56.55	56.22	56.27	5411674.0
2009-08-11 16:00:00	IWM	ETF	56.26	56.41	56.2	56.39	1456722.0
2009-08-11 17:00:00	IWM	ETF	56.38	56.39	56.36	56.37	6470.0
2009-08-11 18:00:00	IWM	ETF	56.29	56.34	56.26	56.34	2290.0
2009-08-11 19:00:00	IWM	ETF	56.28	56.28	56.28	56.28	300.0
2009-08-11 04:00:00	DIA	ETF	93.86	93.86	93.8	93.8	1000.0
2009-08-11 07:00:00	DIA	ETF	93.56	93.56	93.42	93.43	2300.0
2009-08-11 08:00:00	DIA	ETF	93.39	93.72	93.31	93.31	49505.0
2009-08-11 09:00:00	DIA	ETF	93.31	93.33	92.7201	92.92	1318106.0

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

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