PREVIEW / etf_30min / 2009-01-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-15.parquet
  size:    207 KB
  rows:    6,851

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-15 04:00:00	SPY	ETF	83.55	83.55	83.54	83.54	2000.0
2009-01-15 04:30:00	SPY	ETF	83.84	84.05	83.84	84.05	400.0
2009-01-15 05:00:00	SPY	ETF	84.02	84.03	84.02	84.02	20000.0
2009-01-15 05:30:00	SPY	ETF	84.08	84.25	84.08	84.25	718.0
2009-01-15 06:00:00	SPY	ETF	84.32	84.32	84.0	84.0	4900.0
2009-01-15 06:30:00	SPY	ETF	83.93	84.6	83.93	84.27	242505.0
2009-01-15 07:00:00	SPY	ETF	84.26	84.35	83.51	83.73	442149.0
2009-01-15 07:30:00	SPY	ETF	83.72	83.85	83.37	83.62	939315.0
2009-01-15 08:00:00	SPY	ETF	83.62	83.9	83.53	83.84	1820387.0
2009-01-15 08:30:00	SPY	ETF	83.83	84.49	83.7	84.24	2708249.0
2009-01-15 09:00:00	SPY	ETF	84.22	84.29	83.93	84.12	2099444.0
2009-01-15 09:30:00	SPY	ETF	84.12	84.29	82.91	83.3	44115522.0
2009-01-15 10:00:00	SPY	ETF	83.3	83.5	82.15	82.32	42056914.0
2009-01-15 10:30:00	SPY	ETF	82.33	84.3098	82.02	82.38	33949647.0
2009-01-15 11:00:00	SPY	ETF	82.37	82.84	82.34	82.71	22186441.0
2009-01-15 11:30:00	SPY	ETF	82.72	82.85	82.29	82.49	16402761.0
2009-01-15 12:00:00	SPY	ETF	82.49	82.62	82.0	82.09	20011733.0
2009-01-15 12:30:00	SPY	ETF	82.09	82.18	81.72	82.13	25311918.0
2009-01-15 13:00:00	SPY	ETF	82.13	82.59	82.08	82.57	21037060.0
2009-01-15 13:30:00	SPY	ETF	82.57	83.84	82.5	83.67	45990096.0
2009-01-15 14:00:00	SPY	ETF	83.67	84.45	83.3	84.3	52835324.0
2009-01-15 14:30:00	SPY	ETF	84.29	85.25	84.11	84.59	50899621.0
2009-01-15 15:00:00	SPY	ETF	84.59	85.03	84.03	84.2	34819168.0
2009-01-15 15:30:00	SPY	ETF	84.2	84.52	83.3	84.49	57856543.0
2009-01-15 16:00:00	SPY	ETF	84.54	85.23	82.8	84.58	20333024.0
2009-01-15 16:30:00	SPY	ETF	84.6	84.75	83.3	84.49	16312161.0
2009-01-15 17:00:00	SPY	ETF	84.49	84.62	84.46	84.52	3400337.0
2009-01-15 17:30:00	SPY	ETF	84.51	84.77	84.48	84.77	335292.0
2009-01-15 18:00:00	SPY	ETF	84.74	84.98	84.7	84.9	600762.0
2009-01-15 18:30:00	SPY	ETF	84.89	84.97	84.86	84.9	244393.0
2009-01-15 19:00:00	SPY	ETF	84.89	84.95	84.8	84.9	129032.0
2009-01-15 19:30:00	SPY	ETF	84.9	84.95	84.78	84.95	56334.0
2009-01-15 05:00:00	QQQ	ETF	28.2	28.2	28.2	28.2	200.0
2009-01-15 05:30:00	QQQ	ETF	28.28	28.31	28.22	28.31	1300.0
2009-01-15 06:00:00	QQQ	ETF	28.23	28.23	28.15	28.15	400.0
2009-01-15 06:30:00	QQQ	ETF	28.24	28.33	28.24	28.28	25600.0
2009-01-15 07:00:00	QQQ	ETF	28.35	28.35	28.2	28.2	125604.0
2009-01-15 07:30:00	QQQ	ETF	28.27	28.35	28.22	28.35	476873.0
2009-01-15 08:00:00	QQQ	ETF	28.33	28.42	28.15	28.37	905699.0
2009-01-15 08:30:00	QQQ	ETF	28.34	28.67	28.31	28.59	1811549.0
2009-01-15 09:00:00	QQQ	ETF	28.58	28.58	28.46	28.56	489538.0
2009-01-15 09:30:00	QQQ	ETF	28.55	28.62	28.19	28.36	18825200.0
2009-01-15 10:00:00	QQQ	ETF	28.36	28.5	28.08	28.15	17357503.0
2009-01-15 10:30:00	QQQ	ETF	28.15	28.29	28.07	28.18	11379320.0
2009-01-15 11:00:00	QQQ	ETF	28.18	28.34	28.16	28.31	8167598.0
2009-01-15 11:30:00	QQQ	ETF	28.32	28.4	28.24	28.31	7018866.0
2009-01-15 12:00:00	QQQ	ETF	28.31	28.36	28.18	28.2	5184883.0
2009-01-15 12:30:00	QQQ	ETF	28.21	28.32	28.12	28.29	5728735.0
2009-01-15 13:00:00	QQQ	ETF	28.3	28.5	28.3	28.5	8759929.0
2009-01-15 13:30:00	QQQ	ETF	28.5	28.93	28.47	28.84	15849044.0

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

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