PREVIEW / etf_30min / 2009-11-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-06.parquet
  size:    226 KB
  rows:    7,441

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-11-06 04:00:00	SPY	ETF	106.98	106.98	106.97	106.98	1900.0
2009-11-06 04:30:00	SPY	ETF	106.87	106.87	106.87	106.87	1100.0
2009-11-06 05:00:00	SPY	ETF	106.72	106.72	106.68	106.68	300.0
2009-11-06 05:30:00	SPY	ETF	106.84	106.84	106.84	106.84	1000.0
2009-11-06 06:00:00	SPY	ETF	107.0	107.0	106.84	106.84	6400.0
2009-11-06 06:30:00	SPY	ETF	106.94	106.94	106.88	106.9	6300.0
2009-11-06 07:00:00	SPY	ETF	106.87	106.98	106.84	106.86	141739.0
2009-11-06 07:30:00	SPY	ETF	106.91	107.03	106.85	106.97	232104.0
2009-11-06 08:00:00	SPY	ETF	107.0	107.4	106.815	107.14	1498444.0
2009-11-06 08:30:00	SPY	ETF	107.14	107.33	105.85	106.08	11843828.0
2009-11-06 09:00:00	SPY	ETF	106.09	106.33	105.97	106.26	3474180.0
2009-11-06 09:30:00	SPY	ETF	106.26	107.33	106.05	107.17	33669614.0
2009-11-06 10:00:00	SPY	ETF	107.17	107.4	106.55	106.5899	16814347.0
2009-11-06 10:30:00	SPY	ETF	106.59	106.83	106.24	106.771	20086196.0
2009-11-06 11:00:00	SPY	ETF	106.77	106.89	106.53	106.79	8851478.0
2009-11-06 11:30:00	SPY	ETF	106.79	106.99	106.7	106.83	8047171.0
2009-11-06 12:00:00	SPY	ETF	106.83	107.22	106.83	107.1	7247233.0
2009-11-06 12:30:00	SPY	ETF	107.1	107.22	106.85	106.95	8318199.0
2009-11-06 13:00:00	SPY	ETF	106.935	107.17	106.8	107.07	3851517.0
2009-11-06 13:30:00	SPY	ETF	107.08	107.25	106.94	106.99	6223992.0
2009-11-06 14:00:00	SPY	ETF	106.99	107.12	106.855	107.02	5459231.0
2009-11-06 14:30:00	SPY	ETF	107.02	107.1	106.82	106.85	5122172.0
2009-11-06 15:00:00	SPY	ETF	106.85	107.0	106.66	106.99	7795593.0
2009-11-06 15:30:00	SPY	ETF	106.99	107.19	106.8	107.15	15684632.0
2009-11-06 16:00:00	SPY	ETF	107.14	107.4177	106.295	107.18	5588333.0
2009-11-06 16:30:00	SPY	ETF	107.18	107.25	106.8721	107.22	575240.0
2009-11-06 17:00:00	SPY	ETF	107.24	107.29	107.22	107.28	166823.0
2009-11-06 17:30:00	SPY	ETF	107.27	107.3	107.26	107.29	43685.0
2009-11-06 18:00:00	SPY	ETF	107.28	107.29	107.27	107.27	8988.0
2009-11-06 18:30:00	SPY	ETF	107.29	107.3	107.27	107.27	6245.0
2009-11-06 19:00:00	SPY	ETF	107.28	107.29	107.28	107.28	6839.0
2009-11-06 19:30:00	SPY	ETF	107.29	107.32	107.27	107.32	22419.0
2009-11-06 04:00:00	QQQ	ETF	42.35	42.35	42.33	42.33	600.0
2009-11-06 04:30:00	QQQ	ETF	42.35	42.35	42.35	42.35	100.0
2009-11-06 06:00:00	QQQ	ETF	42.4	42.4	42.39	42.39	5150.0
2009-11-06 06:30:00	QQQ	ETF	42.4	42.41	42.4	42.41	10000.0
2009-11-06 07:00:00	QQQ	ETF	42.37	42.43	42.37	42.39	19159.0
2009-11-06 07:30:00	QQQ	ETF	42.39	42.46	42.39	42.45	75530.0
2009-11-06 08:00:00	QQQ	ETF	42.43	42.73	42.43	42.64	795210.0
2009-11-06 08:30:00	QQQ	ETF	42.48	42.49	42.0	42.09	6042759.0
2009-11-06 09:00:00	QQQ	ETF	42.08	42.2	42.05	42.16	1454463.0
2009-11-06 09:30:00	QQQ	ETF	42.16	42.63	42.08	42.57	17102686.0
2009-11-06 10:00:00	QQQ	ETF	42.58	42.65	42.28	42.29	7475360.0
2009-11-06 10:30:00	QQQ	ETF	42.29	42.42	42.19	42.39	11333202.0
2009-11-06 11:00:00	QQQ	ETF	42.385	42.5	42.34	42.425	7303650.0
2009-11-06 11:30:00	QQQ	ETF	42.44	42.49	42.4	42.44	3414595.0
2009-11-06 12:00:00	QQQ	ETF	42.45	42.58	42.445	42.5274	3211836.0
2009-11-06 12:30:00	QQQ	ETF	42.53	42.57	42.41	42.4699	5134496.0
2009-11-06 13:00:00	QQQ	ETF	42.46	42.59	42.43	42.5575	2870107.0
2009-11-06 13:30:00	QQQ	ETF	42.56	42.61	42.49	42.51	3803588.0

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

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