PREVIEW / etf_30min / 2009-09-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-24.parquet
  size:    242 KB
  rows:    7,907

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-09-24 04:00:00	SPY	ETF	105.87	105.9	105.82	105.82	6500.0
2009-09-24 04:30:00	SPY	ETF	105.95	106.05	105.95	106.05	683.0
2009-09-24 05:00:00	SPY	ETF	106.11	106.11	106.11	106.11	700.0
2009-09-24 05:30:00	SPY	ETF	106.28	106.5	106.28	106.5	3800.0
2009-09-24 06:00:00	SPY	ETF	106.4	106.41	106.4	106.41	400.0
2009-09-24 06:30:00	SPY	ETF	106.32	106.39	106.11	106.11	17199.0
2009-09-24 07:00:00	SPY	ETF	106.12	106.31	106.12	106.31	72941.0
2009-09-24 07:30:00	SPY	ETF	106.35	106.41	106.24	106.36	151516.0
2009-09-24 08:00:00	SPY	ETF	106.37	106.57	106.33	106.54	1315207.0
2009-09-24 08:30:00	SPY	ETF	106.55	106.84	106.26	106.72	3978213.0
2009-09-24 09:00:00	SPY	ETF	106.74	106.75	106.39	106.41	1695819.0
2009-09-24 09:30:00	SPY	ETF	106.41	106.64	106.12	106.38	18829094.0
2009-09-24 10:00:00	SPY	ETF	106.34	106.4	105.04	105.33	33447442.0
2009-09-24 10:30:00	SPY	ETF	105.33	105.33	104.77	105.16	22118707.0
2009-09-24 11:00:00	SPY	ETF	105.16	105.35	105.0	105.16	10030160.0
2009-09-24 11:30:00	SPY	ETF	105.15	105.26	104.88	105.04	9752350.0
2009-09-24 12:00:00	SPY	ETF	105.03	105.18	104.94	105.0	5563009.0
2009-09-24 12:30:00	SPY	ETF	104.99	105.09	104.8	104.84	6851718.0
2009-09-24 13:00:00	SPY	ETF	104.84	105.19	104.83	104.95	11077391.0
2009-09-24 13:30:00	SPY	ETF	104.95	105.01	104.62	104.79	10728954.0
2009-09-24 14:00:00	SPY	ETF	104.79	104.9	104.55	104.77	11323555.0
2009-09-24 14:30:00	SPY	ETF	104.7601	105.2	104.75	105.1	14594631.0
2009-09-24 15:00:00	SPY	ETF	105.1	105.33	104.97	105.14	15613228.0
2009-09-24 15:30:00	SPY	ETF	105.1401	105.31	104.95	105.04	23839205.0
2009-09-24 16:00:00	SPY	ETF	105.03	106.53	104.7	104.85	15889930.0
2009-09-24 16:30:00	SPY	ETF	104.85	104.94	104.85	104.89	1340411.0
2009-09-24 17:00:00	SPY	ETF	104.9	105.05	104.81	104.89	1631490.0
2009-09-24 17:30:00	SPY	ETF	104.91	104.91	104.85	104.88	32736.0
2009-09-24 18:00:00	SPY	ETF	104.89	104.95	104.88	104.89	80344.0
2009-09-24 18:30:00	SPY	ETF	104.89	104.92	104.85	104.86	11043.0
2009-09-24 19:00:00	SPY	ETF	104.87	104.87	104.78	104.8	23753.0
2009-09-24 19:30:00	SPY	ETF	104.77	104.81	104.75	104.77	16108.0
2009-09-24 04:30:00	QQQ	ETF	42.36	42.36	42.34	42.36	845.0
2009-09-24 05:00:00	QQQ	ETF	42.42	42.48	42.42	42.48	4000.0
2009-09-24 05:30:00	QQQ	ETF	42.53	42.53	42.53	42.53	100.0
2009-09-24 06:00:00	QQQ	ETF	42.56	42.56	42.55	42.55	15000.0
2009-09-24 07:00:00	QQQ	ETF	42.45	42.55	42.45	42.55	83158.0
2009-09-24 07:30:00	QQQ	ETF	42.57	42.57	42.5	42.55	53600.0
2009-09-24 08:00:00	QQQ	ETF	42.48	42.66	42.48	42.66	978473.0
2009-09-24 08:30:00	QQQ	ETF	42.66	42.77	42.56	42.73	1325107.0
2009-09-24 09:00:00	QQQ	ETF	42.73	42.75	42.61	42.61	889259.0
2009-09-24 09:30:00	QQQ	ETF	42.61	42.69	42.44	42.49	12304651.0
2009-09-24 10:00:00	QQQ	ETF	42.5	42.555	41.97	42.05	17779823.0
2009-09-24 10:30:00	QQQ	ETF	42.05	42.05	41.77	41.9501	10601725.0
2009-09-24 11:00:00	QQQ	ETF	41.95	42.09	41.93	42.0201	4814496.0
2009-09-24 11:30:00	QQQ	ETF	42.03	42.07	41.87	41.928	4064645.0
2009-09-24 12:00:00	QQQ	ETF	41.92	42.0	41.89	41.93	2558282.0
2009-09-24 12:30:00	QQQ	ETF	41.93	41.97	41.86	41.8894	3035404.0
2009-09-24 13:00:00	QQQ	ETF	41.881	42.01	41.88	41.94	3199724.0
2009-09-24 13:30:00	QQQ	ETF	41.9326	41.94	41.8	41.87	4417409.0

> showing 50 of 7,907 rows — these rows as CSV

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