PREVIEW / etf_30min / 2012-10-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-09.parquet
  size:    286 KB
  rows:    9,566

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-10-09 04:00:00	SPY	ETF	145.35	145.38	145.35	145.37	875.0
2012-10-09 04:30:00	SPY	ETF	145.33	145.42	145.33	145.38	7900.0
2012-10-09 05:00:00	SPY	ETF	145.35	145.4	145.26	145.26	550.0
2012-10-09 05:30:00	SPY	ETF	145.32	145.48	145.28	145.42	20250.0
2012-10-09 06:00:00	SPY	ETF	145.48	145.49	145.42	145.48	11050.0
2012-10-09 06:30:00	SPY	ETF	145.42	145.43	145.4	145.43	8950.0
2012-10-09 07:00:00	SPY	ETF	145.48	145.64	145.45	145.62	654124.0
2012-10-09 07:30:00	SPY	ETF	145.6	145.68	145.59	145.65	79060.0
2012-10-09 08:00:00	SPY	ETF	145.64	145.81	145.52	145.78	1113569.0
2012-10-09 08:30:00	SPY	ETF	145.78	145.92	145.76	145.76	304557.0
2012-10-09 09:00:00	SPY	ETF	145.76	145.79	145.5	145.53	724359.0
2012-10-09 09:30:00	SPY	ETF	145.53	145.65	145.25	145.31	14522391.0
2012-10-09 10:00:00	SPY	ETF	145.31	145.58	145.29	145.35	8703597.0
2012-10-09 10:30:00	SPY	ETF	145.35	145.47	144.53	144.66	19384210.0
2012-10-09 11:00:00	SPY	ETF	144.67	144.67	144.35	144.39	15841089.0
2012-10-09 11:30:00	SPY	ETF	144.4	144.54	144.25	144.43	9734535.0
2012-10-09 12:00:00	SPY	ETF	144.43	144.71	144.41	144.54	7859200.0
2012-10-09 12:30:00	SPY	ETF	144.535	144.569	144.33	144.37	7113942.0
2012-10-09 13:00:00	SPY	ETF	144.37	144.62	144.32	144.51	4146338.0
2012-10-09 13:30:00	SPY	ETF	144.51	144.73	144.48	144.53	6796779.0
2012-10-09 14:00:00	SPY	ETF	144.53	145.6217	144.45	144.6399	6500452.0
2012-10-09 14:30:00	SPY	ETF	144.63	144.71	144.4	144.71	6237437.0
2012-10-09 15:00:00	SPY	ETF	144.701	144.78	144.25	144.31	9289827.0
2012-10-09 15:30:00	SPY	ETF	144.31	144.45	144.15	144.21	17727328.0
2012-10-09 16:00:00	SPY	ETF	144.2	145.6217	144.1	144.23	10407016.0
2012-10-09 16:30:00	SPY	ETF	144.24	144.33	144.22	144.3	280377.0
2012-10-09 17:00:00	SPY	ETF	144.27	144.3	144.15	144.23	245123.0
2012-10-09 17:30:00	SPY	ETF	144.23	144.23	144.15	144.15	73505.0
2012-10-09 18:00:00	SPY	ETF	144.17	144.25	144.14	144.15	182025.0
2012-10-09 18:30:00	SPY	ETF	144.14	144.14	144.0	144.01	69719.0
2012-10-09 19:00:00	SPY	ETF	144.04	144.07	143.98	144.07	25520.0
2012-10-09 19:30:00	SPY	ETF	144.07	144.09	143.81	143.88	108503.0
2012-10-09 04:30:00	QQQ	ETF	68.08	68.08	68.08	68.08	100.0
2012-10-09 05:00:00	QQQ	ETF	68.05	68.05	68.02	68.02	200.0
2012-10-09 06:00:00	QQQ	ETF	68.11	68.11	68.11	68.11	1500.0
2012-10-09 06:30:00	QQQ	ETF	68.08	68.13	68.08	68.13	2600.0
2012-10-09 07:00:00	QQQ	ETF	68.13	68.19	68.13	68.18	36800.0
2012-10-09 07:30:00	QQQ	ETF	68.19	68.23	68.19	68.2	21150.0
2012-10-09 08:00:00	QQQ	ETF	68.22	68.28	68.15	68.27	783850.0
2012-10-09 08:30:00	QQQ	ETF	68.27	68.31	68.23	68.25	87935.0
2012-10-09 09:00:00	QQQ	ETF	68.25	68.27	68.17	68.18	114255.0
2012-10-09 09:30:00	QQQ	ETF	68.17	68.18	67.7	67.73	7137113.0
2012-10-09 10:00:00	QQQ	ETF	67.73	67.9	67.64	67.66	3001637.0
2012-10-09 10:30:00	QQQ	ETF	67.66	67.75	67.16	67.275	6627607.0
2012-10-09 11:00:00	QQQ	ETF	67.275	67.32	67.14	67.2	4069851.0
2012-10-09 11:30:00	QQQ	ETF	67.2	67.29	67.1	67.2499	3154686.0
2012-10-09 12:00:00	QQQ	ETF	67.25	67.46	67.22	67.3799	4667065.0
2012-10-09 12:30:00	QQQ	ETF	67.375	67.39	67.195	67.26	1335526.0
2012-10-09 13:00:00	QQQ	ETF	67.27	67.46	67.26	67.39	1955150.0
2012-10-09 13:30:00	QQQ	ETF	67.38	67.5	67.3028	67.39	2135170.0

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

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