PREVIEW / etf_30min / 2011-08-17

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-17.parquet
  size:    287 KB
  rows:    9,549

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
2011-08-17 04:00:00	SPY	ETF	119.5	119.99	119.5	119.66	2100.0
2011-08-17 04:30:00	SPY	ETF	119.47	119.47	119.41	119.41	300.0
2011-08-17 05:00:00	SPY	ETF	119.8	119.9	119.72	119.81	1200.0
2011-08-17 05:30:00	SPY	ETF	119.82	119.96	119.74	119.87	680.0
2011-08-17 06:00:00	SPY	ETF	119.8	119.82	119.6	119.73	23100.0
2011-08-17 06:30:00	SPY	ETF	119.8	120.43	119.7	120.25	152998.0
2011-08-17 07:00:00	SPY	ETF	120.27	120.4	120.12	120.25	502615.0
2011-08-17 07:30:00	SPY	ETF	120.26	120.33	120.14	120.29	347805.0
2011-08-17 08:00:00	SPY	ETF	120.29	120.33	120.03	120.09	386416.0
2011-08-17 08:30:00	SPY	ETF	120.05	120.2	119.92	120.1	811537.0
2011-08-17 09:00:00	SPY	ETF	120.11	120.32	120.06	120.24	1454166.0
2011-08-17 09:30:00	SPY	ETF	120.25	121.18	120.04	121.0	22470521.0
2011-08-17 10:00:00	SPY	ETF	120.99	121.2	120.76	121.18	14953164.0
2011-08-17 10:30:00	SPY	ETF	121.18	121.1866	120.35	120.36	18389715.0
2011-08-17 11:00:00	SPY	ETF	120.35	120.74	120.16	120.28	14089267.0
2011-08-17 11:30:00	SPY	ETF	120.29	120.41	119.59	119.74	17727903.0
2011-08-17 12:00:00	SPY	ETF	119.74	119.86	119.22	119.625	15093834.0
2011-08-17 12:30:00	SPY	ETF	119.6273	119.86	119.22	119.39	10227174.0
2011-08-17 13:00:00	SPY	ETF	119.39	119.55	118.99	119.13	13611338.0
2011-08-17 13:30:00	SPY	ETF	119.135	119.31	118.72	119.11	16089611.0
2011-08-17 14:00:00	SPY	ETF	119.11	119.63	119.1	119.315	11724381.0
2011-08-17 14:30:00	SPY	ETF	119.315	119.56	119.06	119.56	9465049.0
2011-08-17 15:00:00	SPY	ETF	119.56	119.79	119.35	119.61	26122190.0
2011-08-17 15:30:00	SPY	ETF	119.618	119.73	119.36	119.6702	23039379.0
2011-08-17 16:00:00	SPY	ETF	119.7	120.0	119.47	119.5	12440587.0
2011-08-17 16:30:00	SPY	ETF	119.53	119.9176	119.15	119.27	2586205.0
2011-08-17 17:00:00	SPY	ETF	119.28	119.9176	119.25	119.29	5824894.0
2011-08-17 17:30:00	SPY	ETF	119.25	119.35	119.24	119.33	61183.0
2011-08-17 18:00:00	SPY	ETF	119.31	119.67	119.23	119.34	287557.0
2011-08-17 18:30:00	SPY	ETF	119.31	119.37	119.25	119.37	98500.0
2011-08-17 19:00:00	SPY	ETF	119.34	119.37	119.21	119.31	16110.0
2011-08-17 19:30:00	SPY	ETF	119.28	119.39	119.28	119.33	43739.0
2011-08-17 06:00:00	QQQ	ETF	53.83	53.83	53.83	53.83	400.0
2011-08-17 06:30:00	QQQ	ETF	54.02	54.1	54.0	54.08	1000.0
2011-08-17 07:00:00	QQQ	ETF	54.05	54.12	54.02	54.08	52650.0
2011-08-17 07:30:00	QQQ	ETF	54.03	54.1	54.0	54.1	52375.0
2011-08-17 08:00:00	QQQ	ETF	54.08	54.1	53.92	53.95	365629.0
2011-08-17 08:30:00	QQQ	ETF	54.02	54.05	53.91	53.99	239097.0
2011-08-17 09:00:00	QQQ	ETF	53.99	54.05	53.95	53.98	312123.0
2011-08-17 09:30:00	QQQ	ETF	53.98	54.42	53.84	54.34	8804146.0
2011-08-17 10:00:00	QQQ	ETF	54.34	54.36	54.16	54.325	4836239.0
2011-08-17 10:30:00	QQQ	ETF	54.33	54.33	53.88	53.88	5973127.0
2011-08-17 11:00:00	QQQ	ETF	53.88	54.03	53.72	53.77	6251819.0
2011-08-17 11:30:00	QQQ	ETF	53.77	53.85	53.43	53.53	5991618.0
2011-08-17 12:00:00	QQQ	ETF	53.511	53.59	53.26	53.47	6357220.0
2011-08-17 12:30:00	QQQ	ETF	53.47	53.68	53.37	53.46	6023409.0
2011-08-17 13:00:00	QQQ	ETF	53.45	53.45	53.21	53.25	6355249.0
2011-08-17 13:30:00	QQQ	ETF	53.25	53.32	53.02	53.17	7336848.0
2011-08-17 14:00:00	QQQ	ETF	53.17	53.48	53.17	53.3495	3517459.0
2011-08-17 14:30:00	QQQ	ETF	53.35	53.42	53.22	53.42	3306781.0

> showing 50 of 9,549 rows — these rows as CSV

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