PREVIEW / etf_30min / 2012-01-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-23.parquet
  size:    288 KB
  rows:    9,633

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-01-23 04:00:00	SPY	ETF	131.16	131.32	131.09	131.09	6549.0
2012-01-23 04:30:00	SPY	ETF	131.29	131.29	131.08	131.08	1130.0
2012-01-23 05:00:00	SPY	ETF	131.21	131.21	131.21	131.21	200.0
2012-01-23 05:30:00	SPY	ETF	131.37	131.48	131.37	131.4	20700.0
2012-01-23 06:00:00	SPY	ETF	131.65	131.78	131.65	131.76	31700.0
2012-01-23 06:30:00	SPY	ETF	131.7	131.8	131.59	131.61	75575.0
2012-01-23 07:00:00	SPY	ETF	131.63	131.67	131.57	131.61	133846.0
2012-01-23 07:30:00	SPY	ETF	131.62	131.72	131.57	131.64	133242.0
2012-01-23 08:00:00	SPY	ETF	131.67	131.74	131.1	131.48	800297.0
2012-01-23 08:30:00	SPY	ETF	131.47	131.54	131.4	131.5	218757.0
2012-01-23 09:00:00	SPY	ETF	131.48	131.57	131.41	131.48	606135.0
2012-01-23 09:30:00	SPY	ETF	131.51	132.14	131.47	132.08	19558412.0
2012-01-23 10:00:00	SPY	ETF	132.07	132.25	132.02	132.02	9846805.0
2012-01-23 10:30:00	SPY	ETF	132.02	132.11	131.86	131.949	6524695.0
2012-01-23 11:00:00	SPY	ETF	131.95	131.98	131.58	131.71	10859235.0
2012-01-23 11:30:00	SPY	ETF	131.7	131.76	131.26	131.33	9741948.0
2012-01-23 12:00:00	SPY	ETF	131.33	131.35	130.98	131.2	10638420.0
2012-01-23 12:30:00	SPY	ETF	131.2	131.3	131.14	131.16	4834871.0
2012-01-23 13:00:00	SPY	ETF	131.1598	131.37	131.15	131.35	4676732.0
2012-01-23 13:30:00	SPY	ETF	131.36	131.51	131.29	131.49	4926015.0
2012-01-23 14:00:00	SPY	ETF	131.487	131.53	131.36	131.46	5730823.0
2012-01-23 14:30:00	SPY	ETF	131.46	131.61	131.25	131.55	6833730.0
2012-01-23 15:00:00	SPY	ETF	131.56	131.73	131.45	131.685	8660062.0
2012-01-23 15:30:00	SPY	ETF	131.6871	131.825	131.59	131.6	13361312.0
2012-01-23 16:00:00	SPY	ETF	131.6	131.64	131.32	131.58	7596802.0
2012-01-23 16:30:00	SPY	ETF	131.57	132.0748	131.43	131.45	1910158.0
2012-01-23 17:00:00	SPY	ETF	131.43	131.6196	131.43	131.43	192680.0
2012-01-23 17:30:00	SPY	ETF	131.44	131.48	131.43	131.47	38450.0
2012-01-23 18:00:00	SPY	ETF	131.47	131.49	131.44	131.49	48450.0
2012-01-23 18:30:00	SPY	ETF	131.5	131.57	131.5	131.55	19648.0
2012-01-23 19:00:00	SPY	ETF	131.55	131.56	131.45	131.47	16782.0
2012-01-23 19:30:00	SPY	ETF	131.47	131.48	131.45	131.47	54319.0
2012-01-23 04:00:00	QQQ	ETF	59.41	59.6	59.41	59.53	900.0
2012-01-23 04:30:00	QQQ	ETF	59.66	59.66	59.62	59.62	1417.0
2012-01-23 05:30:00	QQQ	ETF	59.75	59.85	59.75	59.81	1525.0
2012-01-23 06:00:00	QQQ	ETF	59.88	59.88	59.88	59.88	600.0
2012-01-23 06:30:00	QQQ	ETF	59.9	59.93	59.86	59.86	3500.0
2012-01-23 07:00:00	QQQ	ETF	59.85	59.89	59.84	59.88	2900.0
2012-01-23 07:30:00	QQQ	ETF	59.86	59.9	59.86	59.86	11015.0
2012-01-23 08:00:00	QQQ	ETF	59.87	59.91	59.8	59.8	86029.0
2012-01-23 08:30:00	QQQ	ETF	59.81	59.82	59.79	59.79	27338.0
2012-01-23 09:00:00	QQQ	ETF	59.79	59.82	59.75	59.8	106391.0
2012-01-23 09:30:00	QQQ	ETF	59.79	60.1	59.73	60.05	4751157.0
2012-01-23 10:00:00	QQQ	ETF	60.04	60.21	60.01	60.012	3398998.0
2012-01-23 10:30:00	QQQ	ETF	60.01	60.09	59.96	60.04	2028143.0
2012-01-23 11:00:00	QQQ	ETF	60.04	60.055	59.78	59.86	3058880.0
2012-01-23 11:30:00	QQQ	ETF	59.86	59.86	59.62	59.63	2110276.0
2012-01-23 12:00:00	QQQ	ETF	59.63	59.64	59.44	59.5695	2460277.0
2012-01-23 12:30:00	QQQ	ETF	59.56	59.65	59.55	59.5801	1231773.0
2012-01-23 13:00:00	QQQ	ETF	59.58	59.66	59.57	59.65	2018557.0

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

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