PREVIEW / etf_30min / 2012-07-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-25.parquet
  size:    280 KB
  rows:    9,407

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-07-25 04:00:00	SPY	ETF	133.4	133.6	133.4	133.6	500.0
2012-07-25 04:30:00	SPY	ETF	133.83	133.85	133.66	133.66	2760.0
2012-07-25 05:00:00	SPY	ETF	133.75	133.89	133.74	133.89	1304.0
2012-07-25 05:30:00	SPY	ETF	133.86	134.03	133.86	134.0	9300.0
2012-07-25 06:00:00	SPY	ETF	134.07	134.07	133.93	133.93	80523.0
2012-07-25 06:30:00	SPY	ETF	133.95	134.26	133.95	134.13	180656.0
2012-07-25 07:00:00	SPY	ETF	134.15	134.24	134.05	134.09	255892.0
2012-07-25 07:30:00	SPY	ETF	134.09	134.29	134.09	134.17	318658.0
2012-07-25 08:00:00	SPY	ETF	134.18	134.42	133.8	134.36	844583.0
2012-07-25 08:30:00	SPY	ETF	134.37	134.62	134.24	134.41	1122123.0
2012-07-25 09:00:00	SPY	ETF	134.41	134.47	134.21	134.21	1038015.0
2012-07-25 09:30:00	SPY	ETF	134.21	134.56	133.92	134.07	15096307.0
2012-07-25 10:00:00	SPY	ETF	134.08	134.08	133.67	133.855	12771083.0
2012-07-25 10:30:00	SPY	ETF	133.855	133.89	133.25	133.3399	10349819.0
2012-07-25 11:00:00	SPY	ETF	133.33	133.75	133.32	133.6	6737830.0
2012-07-25 11:30:00	SPY	ETF	133.6	133.81	133.52	133.64	7425322.0
2012-07-25 12:00:00	SPY	ETF	133.64	133.84	133.56	133.645	4513612.0
2012-07-25 12:30:00	SPY	ETF	133.65	133.97	133.625	133.83	3595366.0
2012-07-25 13:00:00	SPY	ETF	133.83	134.25	133.82	134.216	5909844.0
2012-07-25 13:30:00	SPY	ETF	134.2	134.5	134.135	134.39	7667755.0
2012-07-25 14:00:00	SPY	ETF	134.39	134.47	134.21	134.42	3550814.0
2012-07-25 14:30:00	SPY	ETF	134.42	134.51	134.34	134.35	4407416.0
2012-07-25 15:00:00	SPY	ETF	134.35	134.37	133.84	134.0	7933898.0
2012-07-25 15:30:00	SPY	ETF	133.99	134.01	133.69	133.96	14053647.0
2012-07-25 16:00:00	SPY	ETF	133.96	134.17	133.7151	134.07	12201820.0
2012-07-25 16:30:00	SPY	ETF	134.07	134.08	133.9549	134.06	1499161.0
2012-07-25 17:00:00	SPY	ETF	133.9549	134.15	133.9549	134.15	3857563.0
2012-07-25 17:30:00	SPY	ETF	134.14	134.14	134.08	134.14	43340.0
2012-07-25 18:00:00	SPY	ETF	134.15	134.16	134.05	134.07	21910.0
2012-07-25 18:30:00	SPY	ETF	134.07	134.12	134.05	134.05	6940.0
2012-07-25 19:00:00	SPY	ETF	134.05	134.06	134.03	134.05	17511.0
2012-07-25 19:30:00	SPY	ETF	134.05	134.06	134.0	134.01	34882.0
2012-07-25 04:30:00	QQQ	ETF	62.32	62.32	62.24	62.25	2300.0
2012-07-25 05:00:00	QQQ	ETF	62.25	62.25	62.25	62.25	2000.0
2012-07-25 05:30:00	QQQ	ETF	62.29	62.37	62.29	62.35	2550.0
2012-07-25 06:00:00	QQQ	ETF	62.34	62.34	62.34	62.34	700.0
2012-07-25 06:30:00	QQQ	ETF	62.41	62.42	62.4	62.4	11000.0
2012-07-25 07:00:00	QQQ	ETF	62.38	62.42	62.34	62.41	143922.0
2012-07-25 07:30:00	QQQ	ETF	62.4	62.51	62.4	62.44	219432.0
2012-07-25 08:00:00	QQQ	ETF	62.45	62.53	62.03	62.5	525172.0
2012-07-25 08:30:00	QQQ	ETF	62.51	62.62	62.51	62.59	528366.0
2012-07-25 09:00:00	QQQ	ETF	62.58	62.6	62.43	62.48	385028.0
2012-07-25 09:30:00	QQQ	ETF	62.49	62.89	62.44	62.69	6734964.0
2012-07-25 10:00:00	QQQ	ETF	62.69	62.74	62.35	62.43	4982179.0
2012-07-25 10:30:00	QQQ	ETF	62.43	62.48	62.15	62.21	4325084.0
2012-07-25 11:00:00	QQQ	ETF	62.21	62.57	62.2	62.43	2430210.0
2012-07-25 11:30:00	QQQ	ETF	62.43	62.56	62.4	62.51	2203660.0
2012-07-25 12:00:00	QQQ	ETF	62.5099	62.61	62.44	62.47	1846945.0
2012-07-25 12:30:00	QQQ	ETF	62.48	62.62	62.48	62.585	1374928.0
2012-07-25 13:00:00	QQQ	ETF	62.57	62.82	62.57	62.8	1294048.0

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

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