PREVIEW / etf_30min / 2009-01-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-20.parquet
  size:    208 KB
  rows:    6,962

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-01-20 04:00:00	SPY	ETF	84.95	85.01	84.85	85.01	17700.0
2009-01-20 04:30:00	SPY	ETF	84.98	84.98	84.9	84.9	600.0
2009-01-20 05:00:00	SPY	ETF	84.88	84.88	84.4	84.5	20800.0
2009-01-20 05:30:00	SPY	ETF	84.56	84.56	84.2	84.2	5249.0
2009-01-20 06:00:00	SPY	ETF	84.31	84.47	84.25	84.25	19550.0
2009-01-20 06:30:00	SPY	ETF	84.21	84.41	83.92	84.28	47872.0
2009-01-20 07:00:00	SPY	ETF	84.22	84.78	84.22	84.43	293080.0
2009-01-20 07:30:00	SPY	ETF	84.42	84.49	84.19	84.2	572197.0
2009-01-20 08:00:00	SPY	ETF	84.2	84.65	83.8	83.86	1269294.0
2009-01-20 08:30:00	SPY	ETF	83.86	86.2969	83.86	84.16	2040819.0
2009-01-20 09:00:00	SPY	ETF	84.17	84.34	84.08	84.25	1427287.0
2009-01-20 09:30:00	SPY	ETF	84.23	84.46	82.62	82.85	40757426.0
2009-01-20 10:00:00	SPY	ETF	82.85	83.45	82.43	83.42	30141962.0
2009-01-20 10:30:00	SPY	ETF	83.42	83.46	82.71	82.81	21201899.0
2009-01-20 11:00:00	SPY	ETF	82.81	83.01	82.45	82.58	18072524.0
2009-01-20 11:30:00	SPY	ETF	82.58	83.29	82.57	82.74	20664841.0
2009-01-20 12:00:00	SPY	ETF	82.75	83.24	82.11	82.26	26199892.0
2009-01-20 12:30:00	SPY	ETF	82.27	82.96	82.18	82.47	22173024.0
2009-01-20 13:00:00	SPY	ETF	82.46	82.88	82.19	82.66	21076256.0
2009-01-20 13:30:00	SPY	ETF	82.66	82.67	82.0	82.01	21884737.0
2009-01-20 14:00:00	SPY	ETF	82.02	82.29	81.44	81.85	24864527.0
2009-01-20 14:30:00	SPY	ETF	81.85	84.03	81.33	81.48	23487676.0
2009-01-20 15:00:00	SPY	ETF	81.48	82.9	80.66	81.15	31714669.0
2009-01-20 15:30:00	SPY	ETF	81.14	85.059	80.05	80.62	60664262.0
2009-01-20 16:00:00	SPY	ETF	80.56	85.059	80.18	81.01	14383934.0
2009-01-20 16:30:00	SPY	ETF	81.06	81.1	80.54	80.9	3718120.0
2009-01-20 17:00:00	SPY	ETF	80.88	85.059	80.54	80.87	7254724.0
2009-01-20 17:30:00	SPY	ETF	80.86	80.95	80.57	80.95	11055966.0
2009-01-20 18:00:00	SPY	ETF	80.91	81.13	80.81	80.81	229044.0
2009-01-20 18:30:00	SPY	ETF	80.86	80.9	80.71	80.8	106481.0
2009-01-20 19:00:00	SPY	ETF	80.85	81.0	80.85	80.88	68189.0
2009-01-20 19:30:00	SPY	ETF	80.88	81.14	80.86	80.99	40433.0
2009-01-20 04:00:00	QQQ	ETF	29.39	29.39	29.39	29.39	200.0
2009-01-20 04:30:00	QQQ	ETF	29.39	29.39	29.39	29.39	300.0
2009-01-20 05:00:00	QQQ	ETF	29.36	29.36	29.29	29.29	400.0
2009-01-20 05:30:00	QQQ	ETF	29.27	29.27	29.16	29.16	3275.0
2009-01-20 06:00:00	QQQ	ETF	29.18	29.19	29.18	29.19	200.0
2009-01-20 06:30:00	QQQ	ETF	29.22	29.22	29.16	29.16	900.0
2009-01-20 07:00:00	QQQ	ETF	29.25	29.37	29.25	29.28	33988.0
2009-01-20 07:30:00	QQQ	ETF	29.28	29.35	29.24	29.24	83433.0
2009-01-20 08:00:00	QQQ	ETF	29.24	29.24	29.11	29.12	586495.0
2009-01-20 08:30:00	QQQ	ETF	29.12	29.28	29.12	29.22	195412.0
2009-01-20 09:00:00	QQQ	ETF	29.24	29.32	29.24	29.29	839832.0
2009-01-20 09:30:00	QQQ	ETF	29.29	29.43	28.77	28.8	17535391.0
2009-01-20 10:00:00	QQQ	ETF	28.8	28.92	28.6143	28.9101	13301973.0
2009-01-20 10:30:00	QQQ	ETF	28.92	28.92	28.65	28.69	6950296.0
2009-01-20 11:00:00	QQQ	ETF	28.7	28.77	28.55	28.6	7093299.0
2009-01-20 11:30:00	QQQ	ETF	28.61	28.81	28.58	28.61	5687920.0
2009-01-20 12:00:00	QQQ	ETF	28.61	28.81	28.47	28.52	7527542.0
2009-01-20 12:30:00	QQQ	ETF	28.52	28.68	28.49	28.53	5473535.0

> showing 50 of 6,962 rows — these rows as CSV

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