PREVIEW / etf_1hour / 2009-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-19.parquet
  size:    134 KB
  rows:    4,137

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-03-19 04:00:00	SPY	ETF	79.5	79.52	79.27	79.49	6000.0
2009-03-19 05:00:00	SPY	ETF	79.59	79.66	79.48	79.56	10900.0
2009-03-19 06:00:00	SPY	ETF	79.6	79.83	79.56	79.79	136250.0
2009-03-19 07:00:00	SPY	ETF	79.73	80.41	79.7	80.41	2146146.0
2009-03-19 08:00:00	SPY	ETF	80.4	80.7	80.0	80.63	5473958.0
2009-03-19 09:00:00	SPY	ETF	80.64	81.04	78.0	79.56	54631950.0
2009-03-19 10:00:00	SPY	ETF	79.56	80.2825	79.35	79.7999	74082511.0
2009-03-19 11:00:00	SPY	ETF	79.8	80.2	78.72	79.22	56250545.0
2009-03-19 12:00:00	SPY	ETF	79.22	79.5	78.87	79.0901	43728992.0
2009-03-19 13:00:00	SPY	ETF	79.09	79.69	78.93	79.5	36689533.0
2009-03-19 14:00:00	SPY	ETF	79.51	80.885	78.76	78.97	58312056.0
2009-03-19 15:00:00	SPY	ETF	78.98	80.765	78.69	78.89	60292304.0
2009-03-19 16:00:00	SPY	ETF	78.88	79.79	78.76	78.81	19632687.0
2009-03-19 17:00:00	SPY	ETF	78.79	79.77	78.58	78.62	727552.0
2009-03-19 18:00:00	SPY	ETF	78.62	79.2875	78.51	78.63	119208.0
2009-03-19 19:00:00	SPY	ETF	78.62	78.65	78.55	78.56	27915.0
2009-03-19 04:00:00	QQQ	ETF	29.67	29.67	29.6	29.64	875.0
2009-03-19 05:00:00	QQQ	ETF	29.67	29.7	29.67	29.7	200.0
2009-03-19 06:00:00	QQQ	ETF	29.7	29.73	29.7	29.7	400.0
2009-03-19 07:00:00	QQQ	ETF	29.79	30.04	29.79	30.0	305336.0
2009-03-19 08:00:00	QQQ	ETF	29.99	30.09	29.88	30.09	1167720.0
2009-03-19 09:00:00	QQQ	ETF	30.1	30.15	29.71	29.71	21388025.0
2009-03-19 10:00:00	QQQ	ETF	29.71	29.99	29.66	29.79	26327238.0
2009-03-19 11:00:00	QQQ	ETF	29.79	29.88	29.46	29.6	22081439.0
2009-03-19 12:00:00	QQQ	ETF	29.6022	29.7	29.52	29.57	13684751.0
2009-03-19 13:00:00	QQQ	ETF	29.56	29.75	29.5	29.68	12780211.0
2009-03-19 14:00:00	QQQ	ETF	29.69	29.77	29.55	29.62	12634747.0
2009-03-19 15:00:00	QQQ	ETF	29.62	29.76	29.59	29.7	21670732.0
2009-03-19 16:00:00	QQQ	ETF	29.69	29.74	29.6212	29.65	4623243.0
2009-03-19 17:00:00	QQQ	ETF	29.66	29.71	29.6	29.66	37653.0
2009-03-19 18:00:00	QQQ	ETF	29.6	29.64	29.57	29.58	18926.0
2009-03-19 19:00:00	QQQ	ETF	29.6	29.61	29.57	29.57	8200.0
2009-03-19 05:00:00	IWM	ETF	41.85	41.85	41.85	41.85	100.0
2009-03-19 06:00:00	IWM	ETF	41.7	41.89	41.7	41.89	5000.0
2009-03-19 07:00:00	IWM	ETF	41.89	42.2	41.89	42.16	23346.0
2009-03-19 08:00:00	IWM	ETF	42.15	42.35	42.03	42.23	209377.0
2009-03-19 09:00:00	IWM	ETF	42.24	42.51	41.7	41.73	8572428.0
2009-03-19 10:00:00	IWM	ETF	41.74	42.0	41.44	41.7	10953168.0
2009-03-19 11:00:00	IWM	ETF	41.71	41.92	41.15	41.54	6775634.0
2009-03-19 12:00:00	IWM	ETF	41.55	41.66	41.35	41.42	5744249.0
2009-03-19 13:00:00	IWM	ETF	41.42	41.83	41.28	41.77	5120471.0
2009-03-19 14:00:00	IWM	ETF	41.77	41.98	41.28	41.43	7833122.0
2009-03-19 15:00:00	IWM	ETF	41.42	41.71	41.3	41.37	9847866.0
2009-03-19 16:00:00	IWM	ETF	41.37	41.8452	41.3	41.36	5958249.0
2009-03-19 17:00:00	IWM	ETF	41.42	41.45	41.235	41.29	151899.0
2009-03-19 18:00:00	IWM	ETF	41.4	41.4	41.4	41.4	100.0
2009-03-19 19:00:00	IWM	ETF	41.4	41.4	41.4	41.4	500.0
2009-03-19 07:00:00	DIA	ETF	74.96	75.35	74.96	75.35	11264.0
2009-03-19 08:00:00	DIA	ETF	75.32	75.53	75.1	75.45	80510.0
2009-03-19 09:00:00	DIA	ETF	75.53	75.87	74.66	74.67	4024867.0

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

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