PREVIEW / etf_30min / 2011-08-12

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-12.parquet
  size:    292 KB
  rows:    9,808

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-12 04:00:00	SPY	ETF	116.53	116.61	116.29	116.29	7402.0
2011-08-12 04:30:00	SPY	ETF	116.45	117.27	116.45	116.84	16000.0
2011-08-12 05:00:00	SPY	ETF	116.86	117.37	116.86	117.37	13700.0
2011-08-12 05:30:00	SPY	ETF	117.46	117.87	117.46	117.79	19900.0
2011-08-12 06:00:00	SPY	ETF	117.79	117.84	117.4	117.45	21750.0
2011-08-12 06:30:00	SPY	ETF	117.27	117.64	117.04	117.14	145428.0
2011-08-12 07:00:00	SPY	ETF	117.37	117.78	117.34	117.71	279061.0
2011-08-12 07:30:00	SPY	ETF	117.7	118.21	117.6	117.95	1146372.0
2011-08-12 08:00:00	SPY	ETF	117.95	118.0	117.5	117.5	2570557.0
2011-08-12 08:30:00	SPY	ETF	117.72	118.47	115.64	118.29	2811510.0
2011-08-12 09:00:00	SPY	ETF	118.28	118.81	118.11	118.4	4218160.0
2011-08-12 09:30:00	SPY	ETF	118.4	119.17	117.63	118.015	49639670.0
2011-08-12 10:00:00	SPY	ETF	118.01	118.41	117.28	118.24	37038703.0
2011-08-12 10:30:00	SPY	ETF	118.24	118.63	117.52	117.98	22787956.0
2011-08-12 11:00:00	SPY	ETF	117.98	118.32	117.69	118.15	16410710.0
2011-08-12 11:30:00	SPY	ETF	118.15	119.215	118.04	118.9911	20548749.0
2011-08-12 12:00:00	SPY	ETF	119.0	119.11	118.41	118.65	12844612.0
2011-08-12 12:30:00	SPY	ETF	118.65	118.68	118.23	118.52	13867414.0
2011-08-12 13:00:00	SPY	ETF	118.52	118.7	118.29	118.5	9532285.0
2011-08-12 13:30:00	SPY	ETF	118.5	118.88	118.37	118.78	7289574.0
2011-08-12 14:00:00	SPY	ETF	118.77	118.91	117.85	118.12	21121295.0
2011-08-12 14:30:00	SPY	ETF	118.12	118.33	117.76	118.18	16168839.0
2011-08-12 15:00:00	SPY	ETF	118.17	118.48	118.0	118.04	12232116.0
2011-08-12 15:30:00	SPY	ETF	118.04	118.18	117.61	118.16	35877659.0
2011-08-12 16:00:00	SPY	ETF	118.16	118.59	117.521	118.31	9447373.0
2011-08-12 16:30:00	SPY	ETF	118.32	118.42	117.5209	118.19	11141944.0
2011-08-12 17:00:00	SPY	ETF	118.21	118.36	118.18	118.26	354512.0
2011-08-12 17:30:00	SPY	ETF	118.24	118.34	118.14	118.14	155914.0
2011-08-12 18:00:00	SPY	ETF	118.18	118.3	118.15	118.2	83411.0
2011-08-12 18:30:00	SPY	ETF	118.27	118.28	118.21	118.27	8700.0
2011-08-12 19:00:00	SPY	ETF	118.28	118.32	118.22	118.3	7226.0
2011-08-12 19:30:00	SPY	ETF	118.3	118.33	118.23	118.26	17593.0
2011-08-12 04:00:00	QQQ	ETF	52.5	52.61	52.49	52.61	9822.0
2011-08-12 05:30:00	QQQ	ETF	52.98	53.14	52.98	53.14	200.0
2011-08-12 06:00:00	QQQ	ETF	53.19	53.19	53.1	53.1	900.0
2011-08-12 06:30:00	QQQ	ETF	53.0	53.0	53.0	53.0	250.0
2011-08-12 07:00:00	QQQ	ETF	52.95	53.12	52.95	53.1	54700.0
2011-08-12 07:30:00	QQQ	ETF	53.07	53.29	53.07	53.2	35100.0
2011-08-12 08:00:00	QQQ	ETF	53.17	53.19	52.98	52.99	165050.0
2011-08-12 08:30:00	QQQ	ETF	53.17	53.44	53.15	53.35	666755.0
2011-08-12 09:00:00	QQQ	ETF	53.32	53.56	53.29	53.41	2085565.0
2011-08-12 09:30:00	QQQ	ETF	53.42	53.6	52.94	53.14	15657987.0
2011-08-12 10:00:00	QQQ	ETF	53.14	53.47	52.88	53.42	11837177.0
2011-08-12 10:30:00	QQQ	ETF	53.41	53.6752	53.285	53.46	6664305.0
2011-08-12 11:00:00	QQQ	ETF	53.47	53.59	53.32	53.52	4211203.0
2011-08-12 11:30:00	QQQ	ETF	53.52	53.9	53.5	53.81	5986007.0
2011-08-12 12:00:00	QQQ	ETF	53.81	53.85	53.54	53.6401	3153552.0
2011-08-12 12:30:00	QQQ	ETF	53.64	53.68	53.45	53.58	2284305.0
2011-08-12 13:00:00	QQQ	ETF	53.58	53.72	53.56	53.67	1597138.0
2011-08-12 13:30:00	QQQ	ETF	53.676	53.85	53.6	53.81	2373475.0

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

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