PREVIEW / etf_1hour / 2009-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-07.parquet
  size:    137 KB
  rows:    4,153

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-07 04:00:00	SPY	ETF	89.82	90.03	89.82	90.03	1100.0
2009-07-07 06:00:00	SPY	ETF	90.15	90.24	90.07	90.15	30400.0
2009-07-07 07:00:00	SPY	ETF	90.17	90.24	89.97	89.97	233889.0
2009-07-07 08:00:00	SPY	ETF	89.98	89.98	89.69	89.73	1528676.0
2009-07-07 09:00:00	SPY	ETF	89.75	89.82	89.39	89.5601	21995292.0
2009-07-07 10:00:00	SPY	ETF	89.56	89.58	89.04	89.1299	22184504.0
2009-07-07 11:00:00	SPY	ETF	89.13	89.35	88.79	88.99	20637704.0
2009-07-07 12:00:00	SPY	ETF	88.9899	88.99	88.69	88.85	14076686.0
2009-07-07 13:00:00	SPY	ETF	88.85	89.31	88.8	89.04	20109924.0
2009-07-07 14:00:00	SPY	ETF	89.04	89.06	88.52	88.61	22896444.0
2009-07-07 15:00:00	SPY	ETF	88.6102	89.2	88.0	88.1	56954281.0
2009-07-07 16:00:00	SPY	ETF	88.09	89.9042	88.06	88.28	14056771.0
2009-07-07 17:00:00	SPY	ETF	88.27	88.29	88.1563	88.25	1264673.0
2009-07-07 18:00:00	SPY	ETF	88.29	88.33	88.24	88.26	60901.0
2009-07-07 19:00:00	SPY	ETF	88.24	88.34	88.24	88.25	77401.0
2009-07-07 04:00:00	QQQ	ETF	35.35	35.35	35.35	35.35	1307.0
2009-07-07 05:00:00	QQQ	ETF	35.51	35.53	35.51	35.53	15000.0
2009-07-07 06:00:00	QQQ	ETF	35.57	35.6	35.52	35.55	17850.0
2009-07-07 07:00:00	QQQ	ETF	35.56	35.6	35.53	35.53	118662.0
2009-07-07 08:00:00	QQQ	ETF	35.52	35.53	35.41	35.44	225975.0
2009-07-07 09:00:00	QQQ	ETF	35.44	35.49	35.19	35.23	21771871.0
2009-07-07 10:00:00	QQQ	ETF	35.22	35.22	35.0	35.02	20152352.0
2009-07-07 11:00:00	QQQ	ETF	35.01	35.08	34.8	34.91	18216389.0
2009-07-07 12:00:00	QQQ	ETF	34.9	34.92	34.78	34.84	13127268.0
2009-07-07 13:00:00	QQQ	ETF	34.84	34.97	34.8201	34.881	11180835.0
2009-07-07 14:00:00	QQQ	ETF	34.89	34.94	34.74	34.76	11074823.0
2009-07-07 15:00:00	QQQ	ETF	34.77	34.77	34.51	34.55	33648375.0
2009-07-07 16:00:00	QQQ	ETF	34.53	35.4437	34.51	34.64	10408937.0
2009-07-07 17:00:00	QQQ	ETF	34.64	34.69	34.63	34.66	128283.0
2009-07-07 18:00:00	QQQ	ETF	34.66	34.67	34.55	34.65	135677.0
2009-07-07 19:00:00	QQQ	ETF	34.66	34.66	34.6	34.6	35963.0
2009-07-07 07:00:00	IWM	ETF	49.65	49.75	49.56	49.56	32600.0
2009-07-07 08:00:00	IWM	ETF	49.57	49.77	49.34	49.43	294214.0
2009-07-07 09:00:00	IWM	ETF	49.43	49.5	49.09	49.3	4667297.0
2009-07-07 10:00:00	IWM	ETF	49.29	49.29	48.88	49.03	5190173.0
2009-07-07 11:00:00	IWM	ETF	49.03	49.13	48.81	48.988	3189729.0
2009-07-07 12:00:00	IWM	ETF	48.98	48.99	48.82	48.88	1976410.0
2009-07-07 13:00:00	IWM	ETF	48.88	49.12	48.87	49.05	3595152.0
2009-07-07 14:00:00	IWM	ETF	49.05	49.11	48.76	48.82	5598555.0
2009-07-07 15:00:00	IWM	ETF	48.82	49.2	48.38	48.39	13248332.0
2009-07-07 16:00:00	IWM	ETF	48.39	48.65	48.35	48.56	1343582.0
2009-07-07 17:00:00	IWM	ETF	48.56	48.61	48.53	48.54	4172.0
2009-07-07 18:00:00	IWM	ETF	48.53	48.55	48.51	48.53	1100.0
2009-07-07 19:00:00	IWM	ETF	48.53	48.53	48.53	48.53	1898.0
2009-07-07 07:00:00	DIA	ETF	83.55	83.55	83.45	83.45	800.0
2009-07-07 08:00:00	DIA	ETF	83.38	83.38	83.18	83.18	26173.0
2009-07-07 09:00:00	DIA	ETF	83.16	83.21	82.75	82.87	2039589.0
2009-07-07 10:00:00	DIA	ETF	82.85	82.85	82.41	82.46	1933557.0
2009-07-07 11:00:00	DIA	ETF	82.46	82.6	82.21	82.38	1390882.0
2009-07-07 12:00:00	DIA	ETF	82.38	82.41	82.15	82.25	928876.0

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

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