PREVIEW / etf_30min / 2012-09-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-12.parquet
  size:    282 KB
  rows:    9,841

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-09-12 04:00:00	SPY	ETF	143.93	144.54	143.93	144.4	107405.0
2012-09-12 04:30:00	SPY	ETF	144.32	144.6	144.3	144.4	24965.0
2012-09-12 05:00:00	SPY	ETF	144.4	144.45	144.33	144.45	32619.0
2012-09-12 05:30:00	SPY	ETF	144.47	144.54	144.43	144.54	3670.0
2012-09-12 06:00:00	SPY	ETF	144.52	144.52	144.38	144.4	29300.0
2012-09-12 06:30:00	SPY	ETF	144.38	144.39	144.25	144.28	91600.0
2012-09-12 07:00:00	SPY	ETF	144.3	144.42	144.28	144.4	244505.0
2012-09-12 07:30:00	SPY	ETF	144.4	144.42	144.11	144.19	133801.0
2012-09-12 08:00:00	SPY	ETF	144.22	144.4	144.1	144.29	388285.0
2012-09-12 08:30:00	SPY	ETF	144.29	144.31	144.16	144.24	502400.0
2012-09-12 09:00:00	SPY	ETF	144.22	144.47	144.15	144.38	886533.0
2012-09-12 09:30:00	SPY	ETF	144.39	144.55	144.32	144.35	12100917.0
2012-09-12 10:00:00	SPY	ETF	144.36	144.47	144.2	144.21	6662217.0
2012-09-12 10:30:00	SPY	ETF	144.2	144.24	143.95	144.18	8617202.0
2012-09-12 11:00:00	SPY	ETF	144.18	144.42	144.171	144.32	5361832.0
2012-09-12 11:30:00	SPY	ETF	144.33	144.42	144.25	144.2701	4447269.0
2012-09-12 12:00:00	SPY	ETF	144.28	144.34	144.14	144.2899	3449562.0
2012-09-12 12:30:00	SPY	ETF	144.285	144.33	144.23	144.32	1750728.0
2012-09-12 13:00:00	SPY	ETF	144.32	144.53	144.25	144.33	5718792.0
2012-09-12 13:30:00	SPY	ETF	144.33	144.45	144.3	144.35	3516935.0
2012-09-12 14:00:00	SPY	ETF	144.36	144.409	144.19	144.31	3893037.0
2012-09-12 14:30:00	SPY	ETF	144.3	144.35	144.1	144.16	4414870.0
2012-09-12 15:00:00	SPY	ETF	144.155	144.18	143.9	144.16	6540013.0
2012-09-12 15:30:00	SPY	ETF	144.16	144.33	144.07	144.33	10512097.0
2012-09-12 16:00:00	SPY	ETF	144.33	144.65	144.33	144.49	3422693.0
2012-09-12 16:30:00	SPY	ETF	144.48	144.51	144.4	144.44	2193241.0
2012-09-12 17:00:00	SPY	ETF	144.43	144.53	144.43	144.5	2106962.0
2012-09-12 17:30:00	SPY	ETF	144.53	144.53	144.44	144.44	16000.0
2012-09-12 18:00:00	SPY	ETF	144.49	144.52	144.46	144.48	9587.0
2012-09-12 18:30:00	SPY	ETF	144.5	144.53	144.5	144.5	5179.0
2012-09-12 19:00:00	SPY	ETF	144.53	144.55	144.48	144.48	16133.0
2012-09-12 19:30:00	SPY	ETF	144.48	144.57	144.48	144.53	13483.0
2012-09-12 04:00:00	QQQ	ETF	68.63	68.63	68.63	68.63	2200.0
2012-09-12 04:30:00	QQQ	ETF	68.7	68.7	68.7	68.7	1000.0
2012-09-12 05:00:00	QQQ	ETF	68.79	68.79	68.79	68.79	100.0
2012-09-12 05:30:00	QQQ	ETF	68.75	68.75	68.75	68.75	600.0
2012-09-12 06:00:00	QQQ	ETF	68.81	68.81	68.74	68.77	10300.0
2012-09-12 06:30:00	QQQ	ETF	68.76	68.77	68.7	68.7	6240.0
2012-09-12 07:00:00	QQQ	ETF	68.7	68.72	68.67	68.72	19840.0
2012-09-12 07:30:00	QQQ	ETF	68.71	68.72	68.59	68.6	10499.0
2012-09-12 08:00:00	QQQ	ETF	68.63	68.7	68.59	68.7	54526.0
2012-09-12 08:30:00	QQQ	ETF	68.68	68.7	68.64	68.65	43257.0
2012-09-12 09:00:00	QQQ	ETF	68.66	68.73	68.64	68.68	160583.0
2012-09-12 09:30:00	QQQ	ETF	68.68	68.81	68.55	68.599	4205198.0
2012-09-12 10:00:00	QQQ	ETF	68.6	68.64	68.43	68.45	2455653.0
2012-09-12 10:30:00	QQQ	ETF	68.45	68.518	68.34	68.48	2367206.0
2012-09-12 11:00:00	QQQ	ETF	68.48	68.52	68.4	68.45	1995596.0
2012-09-12 11:30:00	QQQ	ETF	68.45	68.59	68.45	68.53	1878242.0
2012-09-12 12:00:00	QQQ	ETF	68.54	68.57	68.4001	68.49	864507.0
2012-09-12 12:30:00	QQQ	ETF	68.5	68.57	68.49	68.56	1016137.0

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

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