PREVIEW / etf_30min / 2012-03-22

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-22.parquet
  size:    289 KB
  rows:    9,937

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
2012-03-22 04:00:00	SPY	ETF	140.2	140.2	139.77	139.77	3550.0
2012-03-22 04:30:00	SPY	ETF	139.65	139.65	139.4	139.4	6596.0
2012-03-22 05:00:00	SPY	ETF	139.45	139.45	139.26	139.33	1590.0
2012-03-22 05:30:00	SPY	ETF	139.25	139.35	139.2	139.35	9840.0
2012-03-22 06:00:00	SPY	ETF	139.35	139.45	139.26	139.31	27521.0
2012-03-22 06:30:00	SPY	ETF	139.31	139.45	139.31	139.45	46185.0
2012-03-22 07:00:00	SPY	ETF	139.4	139.49	139.37	139.4	207684.0
2012-03-22 07:30:00	SPY	ETF	139.4	139.46	139.27	139.27	135317.0
2012-03-22 08:00:00	SPY	ETF	139.3	140.0	139.26	139.49	1001524.0
2012-03-22 08:30:00	SPY	ETF	139.45	140.16	139.36	139.49	802007.0
2012-03-22 09:00:00	SPY	ETF	139.49	139.53	139.1	139.18	1272033.0
2012-03-22 09:30:00	SPY	ETF	139.18	139.48	139.14	139.33	21352110.0
2012-03-22 10:00:00	SPY	ETF	139.33	139.55	139.12	139.27	12096043.0
2012-03-22 10:30:00	SPY	ETF	139.27	139.28	138.89	138.95	13891049.0
2012-03-22 11:00:00	SPY	ETF	138.96	139.11	138.75	139.06	8656497.0
2012-03-22 11:30:00	SPY	ETF	139.06	139.18	139.02	139.12	4820046.0
2012-03-22 12:00:00	SPY	ETF	139.125	139.31	139.12	139.23	5098226.0
2012-03-22 12:30:00	SPY	ETF	139.23	139.38	139.14	139.38	5257729.0
2012-03-22 13:00:00	SPY	ETF	139.38	139.39	139.18	139.29	5324252.0
2012-03-22 13:30:00	SPY	ETF	139.29	139.38	139.16	139.2308	6244490.0
2012-03-22 14:00:00	SPY	ETF	139.24	139.26	139.08	139.2499	6840806.0
2012-03-22 14:30:00	SPY	ETF	139.24	139.27	139.03	139.075	5431473.0
2012-03-22 15:00:00	SPY	ETF	139.08	139.08	138.74	139.0001	9946724.0
2012-03-22 15:30:00	SPY	ETF	139.0	139.36	138.95	139.17	21060388.0
2012-03-22 16:00:00	SPY	ETF	139.18	139.4	139.15	139.35	4422487.0
2012-03-22 16:30:00	SPY	ETF	139.35	139.43	139.35	139.43	482854.0
2012-03-22 17:00:00	SPY	ETF	139.42	139.49	139.42	139.45	149269.0
2012-03-22 17:30:00	SPY	ETF	139.45	139.48	139.44	139.45	51154.0
2012-03-22 18:00:00	SPY	ETF	139.46	139.47	139.4	139.44	95700.0
2012-03-22 18:30:00	SPY	ETF	139.44	139.45	139.39	139.39	15235.0
2012-03-22 19:00:00	SPY	ETF	139.39	139.41	139.35	139.37	11415.0
2012-03-22 19:30:00	SPY	ETF	139.36	139.46	139.34	139.44	59341.0
2012-03-22 04:00:00	QQQ	ETF	67.04	67.04	66.97	66.97	875.0
2012-03-22 04:30:00	QQQ	ETF	66.85	66.86	66.84	66.86	1740.0
2012-03-22 06:00:00	QQQ	ETF	66.77	66.88	66.76	66.86	23400.0
2012-03-22 06:30:00	QQQ	ETF	66.82	66.84	66.81	66.84	13500.0
2012-03-22 07:00:00	QQQ	ETF	66.84	66.88	66.84	66.85	12350.0
2012-03-22 07:30:00	QQQ	ETF	66.84	66.84	66.77	66.77	160648.0
2012-03-22 08:00:00	QQQ	ETF	66.79	66.87	66.77	66.82	189735.0
2012-03-22 08:30:00	QQQ	ETF	66.83	66.92	66.81	66.88	302465.0
2012-03-22 09:00:00	QQQ	ETF	66.87	66.89	66.68	66.72	358348.0
2012-03-22 09:30:00	QQQ	ETF	66.71	66.99	66.7	66.92	12435585.0
2012-03-22 10:00:00	QQQ	ETF	66.91	67.06	66.8	66.86	3544989.0
2012-03-22 10:30:00	QQQ	ETF	66.87	66.98	66.77	66.8	5009284.0
2012-03-22 11:00:00	QQQ	ETF	66.8	66.885	66.71	66.87	2810440.0
2012-03-22 11:30:00	QQQ	ETF	66.87	66.955	66.87	66.93	1515842.0
2012-03-22 12:00:00	QQQ	ETF	66.94	67.05	66.935	67.04	1735500.0
2012-03-22 12:30:00	QQQ	ETF	67.031	67.14	66.961	67.13	2155133.0
2012-03-22 13:00:00	QQQ	ETF	67.13	67.13	66.991	67.07	3313946.0
2012-03-22 13:30:00	QQQ	ETF	67.075	67.13	66.97	67.0299	1908796.0

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

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