PREVIEW / etf_30min / 2011-01-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-18.parquet
  size:    277 KB
  rows:    9,405

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
2011-01-18 04:00:00	SPY	ETF	129.39	129.49	129.39	129.47	300.0
2011-01-18 04:30:00	SPY	ETF	129.43	129.5	129.43	129.5	1500.0
2011-01-18 05:00:00	SPY	ETF	129.54	129.55	129.5	129.55	5100.0
2011-01-18 05:30:00	SPY	ETF	129.55	129.57	129.53	129.53	21700.0
2011-01-18 06:00:00	SPY	ETF	129.64	129.64	129.62	129.62	3400.0
2011-01-18 06:30:00	SPY	ETF	129.64	129.71	129.64	129.67	9200.0
2011-01-18 07:00:00	SPY	ETF	129.62	129.68	129.44	129.46	192920.0
2011-01-18 07:30:00	SPY	ETF	129.44	129.47	129.36	129.47	192020.0
2011-01-18 08:00:00	SPY	ETF	129.45	129.72	128.7	129.25	859039.0
2011-01-18 08:30:00	SPY	ETF	129.25	129.44	129.15	129.19	670399.0
2011-01-18 09:00:00	SPY	ETF	129.18	129.26	129.12	129.18	787859.0
2011-01-18 09:30:00	SPY	ETF	129.18	129.44	129.04	129.17	16987787.0
2011-01-18 10:00:00	SPY	ETF	129.17	129.48	129.03	129.3938	13502902.0
2011-01-18 10:30:00	SPY	ETF	129.4	129.41	129.11	129.2	7855909.0
2011-01-18 11:00:00	SPY	ETF	129.2	129.43	129.19	129.42	5487470.0
2011-01-18 11:30:00	SPY	ETF	129.425	129.46	129.3	129.35	4790483.0
2011-01-18 12:00:00	SPY	ETF	129.35	129.37	129.26	129.308	5352474.0
2011-01-18 12:30:00	SPY	ETF	129.28	129.39	129.26	129.35	3139980.0
2011-01-18 13:00:00	SPY	ETF	129.35	129.44	129.35	129.44	3881077.0
2011-01-18 13:30:00	SPY	ETF	129.44	129.53	129.37	129.43	6733281.0
2011-01-18 14:00:00	SPY	ETF	129.42	129.52	129.38	129.52	3461162.0
2011-01-18 14:30:00	SPY	ETF	129.51	129.56	129.41	129.515	6310376.0
2011-01-18 15:00:00	SPY	ETF	129.52	129.52	129.36	129.5	4826007.0
2011-01-18 15:30:00	SPY	ETF	129.49	129.64	129.48	129.53	13225306.0
2011-01-18 16:00:00	SPY	ETF	129.54	129.9	129.2721	129.85	9001099.0
2011-01-18 16:30:00	SPY	ETF	129.85	130.01	129.72	129.75	780762.0
2011-01-18 17:00:00	SPY	ETF	129.75	129.78	129.5188	129.77	760854.0
2011-01-18 17:30:00	SPY	ETF	129.75	129.82	129.71	129.77	6078.0
2011-01-18 18:00:00	SPY	ETF	129.75	129.79	129.53	129.68	94309.0
2011-01-18 18:30:00	SPY	ETF	129.68	129.74	129.68	129.73	18249.0
2011-01-18 19:00:00	SPY	ETF	129.7	129.72	129.68	129.68	30889.0
2011-01-18 19:30:00	SPY	ETF	129.68	129.82	129.68	129.78	30234.0
2011-01-18 04:00:00	QQQ	ETF	56.62	56.62	56.57	56.59	2820.0
2011-01-18 04:30:00	QQQ	ETF	56.64	56.65	56.62	56.62	700.0
2011-01-18 05:00:00	QQQ	ETF	56.66	56.66	56.66	56.66	1000.0
2011-01-18 05:30:00	QQQ	ETF	56.71	56.71	56.71	56.71	300.0
2011-01-18 06:00:00	QQQ	ETF	56.69	56.71	56.69	56.69	3300.0
2011-01-18 06:30:00	QQQ	ETF	56.72	56.76	56.72	56.75	5200.0
2011-01-18 07:00:00	QQQ	ETF	56.75	56.75	56.62	56.63	147315.0
2011-01-18 07:30:00	QQQ	ETF	56.63	56.67	56.58	56.67	223328.0
2011-01-18 08:00:00	QQQ	ETF	56.67	56.67	56.54	56.57	366584.0
2011-01-18 08:30:00	QQQ	ETF	56.57	56.58	56.52	56.54	332160.0
2011-01-18 09:00:00	QQQ	ETF	56.54	56.57	56.5	56.52	515586.0
2011-01-18 09:30:00	QQQ	ETF	56.52	56.96	56.4983	56.77	14680130.0
2011-01-18 10:00:00	QQQ	ETF	56.77	56.94	56.72	56.9	5499643.0
2011-01-18 10:30:00	QQQ	ETF	56.89	56.91	56.76	56.8	2381605.0
2011-01-18 11:00:00	QQQ	ETF	56.8	57.01	56.79	57.0	3957331.0
2011-01-18 11:30:00	QQQ	ETF	57.0	57.0	56.93	56.971	2034957.0
2011-01-18 12:00:00	QQQ	ETF	56.975	57.0	56.9	56.97	3041378.0
2011-01-18 12:30:00	QQQ	ETF	56.97	57.05	56.96	57.01	2723714.0

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

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