PREVIEW / etf_30min / 2012-03-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-16.parquet
  size:    275 KB
  rows:    9,446

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-16 04:00:00	SPY	ETF	140.3	140.38	139.96	140.04	2503.0
2012-03-16 04:30:00	SPY	ETF	140.09	140.09	140.09	140.09	500.0
2012-03-16 05:00:00	SPY	ETF	140.01	140.01	140.0	140.0	5200.0
2012-03-16 05:30:00	SPY	ETF	140.04	140.05	140.03	140.03	2950.0
2012-03-16 06:00:00	SPY	ETF	140.08	140.1	140.08	140.1	2385.0
2012-03-16 06:30:00	SPY	ETF	140.1	140.15	140.05	140.1	18600.0
2012-03-16 07:00:00	SPY	ETF	140.06	140.19	140.03	140.14	52090.0
2012-03-16 07:30:00	SPY	ETF	140.19	140.33	140.19	140.31	214455.0
2012-03-16 08:00:00	SPY	ETF	140.31	140.34	140.19	140.24	197855.0
2012-03-16 08:30:00	SPY	ETF	140.27	140.46	140.25	140.42	722172.0
2012-03-16 09:00:00	SPY	ETF	140.4	140.44	140.29	140.36	2765049.0
2012-03-16 09:30:00	SPY	ETF	140.36	140.45	140.06	140.13	24299402.0
2012-03-16 10:00:00	SPY	ETF	140.13	140.3883	140.0	140.1317	11835533.0
2012-03-16 10:30:00	SPY	ETF	140.14	140.36	140.09	140.36	11811298.0
2012-03-16 11:00:00	SPY	ETF	140.36	140.43	140.18	140.25	8491198.0
2012-03-16 11:30:00	SPY	ETF	140.25	140.38	140.17	140.36	16652422.0
2012-03-16 12:00:00	SPY	ETF	140.36	140.4	140.28	140.37	5332998.0
2012-03-16 12:30:00	SPY	ETF	140.365	140.48	140.29	140.31	4810678.0
2012-03-16 13:00:00	SPY	ETF	140.31	140.36	140.29	140.31	3578748.0
2012-03-16 13:30:00	SPY	ETF	140.32	140.37	140.27	140.3593	3967835.0
2012-03-16 14:00:00	SPY	ETF	140.3569	140.41	140.33	140.375	2768395.0
2012-03-16 14:30:00	SPY	ETF	140.37	140.43	140.34	140.365	4454259.0
2012-03-16 15:00:00	SPY	ETF	140.37	140.38	140.12	140.27	8979966.0
2012-03-16 15:30:00	SPY	ETF	140.27	140.4	140.17	140.3	16587205.0
2012-03-16 16:00:00	SPY	ETF	140.31	140.42	140.1348	140.39	18264378.0
2012-03-16 16:30:00	SPY	ETF	140.39	140.52	140.3	140.46	3018572.0
2012-03-16 17:00:00	SPY	ETF	140.48	140.52	140.36	140.47	96885.0
2012-03-16 17:30:00	SPY	ETF	140.4	140.54	140.4	140.43	160859.0
2012-03-16 18:00:00	SPY	ETF	140.45	140.46	140.37	140.44	95230.0
2012-03-16 18:30:00	SPY	ETF	140.1348	140.43	140.1348	140.41	1003010.0
2012-03-16 19:00:00	SPY	ETF	140.42	140.47	140.42	140.46	2912.0
2012-03-16 19:30:00	SPY	ETF	140.42	140.44	140.4	140.4	12287.0
2012-03-16 07:00:00	QQQ	ETF	66.68	66.68	66.62	66.68	6300.0
2012-03-16 07:30:00	QQQ	ETF	66.71	66.78	66.68	66.74	12050.0
2012-03-16 08:00:00	QQQ	ETF	66.78	66.78	66.68	66.73	755601.0
2012-03-16 08:30:00	QQQ	ETF	66.72	66.78	66.71	66.76	409425.0
2012-03-16 09:00:00	QQQ	ETF	66.75	66.75	66.64	66.67	1329751.0
2012-03-16 09:30:00	QQQ	ETF	66.66	66.67	66.39	66.492	7282324.0
2012-03-16 10:00:00	QQQ	ETF	66.49	66.53	66.36	66.51	3796323.0
2012-03-16 10:30:00	QQQ	ETF	66.5186	66.67	66.46	66.61	3025055.0
2012-03-16 11:00:00	QQQ	ETF	66.62	66.66	66.485	66.5	2071032.0
2012-03-16 11:30:00	QQQ	ETF	66.505	66.625	66.49	66.61	2033944.0
2012-03-16 12:00:00	QQQ	ETF	66.62	66.63	66.55	66.59	1181705.0
2012-03-16 12:30:00	QQQ	ETF	66.6	66.62	66.48	66.51	1643795.0
2012-03-16 13:00:00	QQQ	ETF	66.5	66.5712	66.49	66.53	993652.0
2012-03-16 13:30:00	QQQ	ETF	66.54	66.57	66.51	66.54	720527.0
2012-03-16 14:00:00	QQQ	ETF	66.5486	66.6	66.52	66.565	2096598.0
2012-03-16 14:30:00	QQQ	ETF	66.55	66.58	66.5201	66.5201	1542580.0
2012-03-16 15:00:00	QQQ	ETF	66.5299	66.53	66.41	66.479	4309170.0
2012-03-16 15:30:00	QQQ	ETF	66.4719	66.53	66.43	66.49	4084512.0

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

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