PREVIEW / etf_30min / 2011-01-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-11.parquet
  size:    271 KB
  rows:    9,079

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-01-11 04:00:00	SPY	ETF	127.15	127.15	127.05	127.05	1200.0
2011-01-11 04:30:00	SPY	ETF	127.03	127.03	127.0	127.0	2400.0
2011-01-11 05:00:00	SPY	ETF	127.05	127.14	127.05	127.12	500.0
2011-01-11 05:30:00	SPY	ETF	127.15	127.19	127.13	127.19	27300.0
2011-01-11 06:00:00	SPY	ETF	127.19	127.37	127.19	127.33	8950.0
2011-01-11 06:30:00	SPY	ETF	127.35	127.44	127.35	127.38	21073.0
2011-01-11 07:00:00	SPY	ETF	127.43	127.63	127.43	127.5	242540.0
2011-01-11 07:30:00	SPY	ETF	127.54	127.54	127.45	127.51	163484.0
2011-01-11 08:00:00	SPY	ETF	127.48	127.51	127.4	127.47	166593.0
2011-01-11 08:30:00	SPY	ETF	127.47	127.58	127.44	127.56	822809.0
2011-01-11 09:00:00	SPY	ETF	127.56	127.56	127.44	127.44	575746.0
2011-01-11 09:30:00	SPY	ETF	127.44	127.68	127.27	127.28	11826951.0
2011-01-11 10:00:00	SPY	ETF	127.29	127.48	127.23	127.435	7601451.0
2011-01-11 10:30:00	SPY	ETF	127.43	127.56	127.35	127.54	5376918.0
2011-01-11 11:00:00	SPY	ETF	127.54	127.74	127.535	127.67	8704833.0
2011-01-11 11:30:00	SPY	ETF	127.67	127.71	127.52	127.61	5455622.0
2011-01-11 12:00:00	SPY	ETF	127.61	127.645	127.53	127.62	2856126.0
2011-01-11 12:30:00	SPY	ETF	127.61	127.71	127.6	127.69	4226686.0
2011-01-11 13:00:00	SPY	ETF	127.685	127.72	127.18	127.41	14797642.0
2011-01-11 13:30:00	SPY	ETF	127.42	127.47	127.1	127.14	7590038.0
2011-01-11 14:00:00	SPY	ETF	127.15	127.32	126.95	127.3	9640126.0
2011-01-11 14:30:00	SPY	ETF	127.3	127.32	127.14	127.29	5759458.0
2011-01-11 15:00:00	SPY	ETF	127.29	127.43	127.24	127.3199	5577137.0
2011-01-11 15:30:00	SPY	ETF	127.31	127.51	127.26	127.43	12032524.0
2011-01-11 16:00:00	SPY	ETF	127.43	127.735	127.18	127.39	5081427.0
2011-01-11 16:30:00	SPY	ETF	127.38	127.423	127.36	127.37	1307918.0
2011-01-11 17:00:00	SPY	ETF	127.37	127.37	127.3	127.35	56515.0
2011-01-11 17:30:00	SPY	ETF	127.4	127.4	127.33	127.36	2990.0
2011-01-11 18:00:00	SPY	ETF	127.35	127.43	127.33	127.36	74170.0
2011-01-11 18:30:00	SPY	ETF	127.36	127.43	127.33	127.43	42990.0
2011-01-11 19:00:00	SPY	ETF	127.44	127.44	127.41	127.42	17961.0
2011-01-11 19:30:00	SPY	ETF	127.42	127.5	127.4	127.5	28582.0
2011-01-11 04:00:00	QQQ	ETF	56.15	56.15	56.15	56.15	300.0
2011-01-11 04:30:00	QQQ	ETF	56.14	56.14	56.14	56.14	100.0
2011-01-11 06:30:00	QQQ	ETF	56.23	56.3	56.23	56.3	41513.0
2011-01-11 07:00:00	QQQ	ETF	56.33	56.37	56.31	56.36	132863.0
2011-01-11 07:30:00	QQQ	ETF	56.32	56.35	56.3	56.31	25370.0
2011-01-11 08:00:00	QQQ	ETF	56.31	56.32	56.27	56.3	27561.0
2011-01-11 08:30:00	QQQ	ETF	56.3	56.35	56.3	56.34	86650.0
2011-01-11 09:00:00	QQQ	ETF	56.33	56.33	56.29	56.29	235189.0
2011-01-11 09:30:00	QQQ	ETF	56.29	56.36	56.12	56.1264	5672663.0
2011-01-11 10:00:00	QQQ	ETF	56.13	56.25	56.1	56.21	3398191.0
2011-01-11 10:30:00	QQQ	ETF	56.21	56.22	56.12	56.22	2433972.0
2011-01-11 11:00:00	QQQ	ETF	56.22	56.279	56.17	56.21	6112941.0
2011-01-11 11:30:00	QQQ	ETF	56.22	56.2781	56.15	56.185	5909408.0
2011-01-11 12:00:00	QQQ	ETF	56.18	56.24	56.15	56.24	1383247.0
2011-01-11 12:30:00	QQQ	ETF	56.23	56.265	56.21	56.2435	914809.0
2011-01-11 13:00:00	QQQ	ETF	56.25	56.25	56.06	56.15	4848216.0
2011-01-11 13:30:00	QQQ	ETF	56.1501	56.2	56.02	56.04	3747317.0
2011-01-11 14:00:00	QQQ	ETF	56.0499	56.11	55.95	56.09	2495040.0

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

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