PREVIEW / stock_30min / 2012-05-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-07.parquet
  size:    1.4 MB
  rows:    75,888
  symbols: 3,527

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-05-07 04:00:00	AAPL	Stock	20.0714	20.0714	20.025	20.0325	30296.0
2012-05-07 04:30:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	14000.0
2012-05-07 05:00:00	AAPL	Stock	20.1029	20.1029	20.1029	20.1029	2800.0
2012-05-07 05:30:00	AAPL	Stock	20.1029	20.125	20.1029	20.125	21000.0
2012-05-07 06:00:00	AAPL	Stock	20.1075	20.1607	20.1075	20.1596	25200.0
2012-05-07 06:30:00	AAPL	Stock	20.1596	20.1596	20.15	20.15	11480.0
2012-05-07 07:00:00	AAPL	Stock	20.1082	20.1082	20.0214	20.0943	700812.0
2012-05-07 07:30:00	AAPL	Stock	20.0964	20.1	20.0721	20.0964	374500.0
2012-05-07 08:00:00	AAPL	Stock	20.0821	20.1064	20.0107	20.05	2355836.0
2012-05-07 08:30:00	AAPL	Stock	20.0525	20.1232	20.0382	20.1054	1037148.0
2012-05-07 09:00:00	AAPL	Stock	20.1064	20.1732	20.0536	20.0536	3159464.0
2012-05-07 09:30:00	AAPL	Stock	20.0643	20.4561	20.0439	20.2725	114585828.0
2012-05-07 10:00:00	AAPL	Stock	20.2725	20.3311	20.1857	20.1929	55352752.0
2012-05-07 10:30:00	AAPL	Stock	20.1932	20.2121	20.0639	20.2059	44566424.0
2012-05-07 11:00:00	AAPL	Stock	20.2029	20.2375	20.12	20.1221	26937036.0
2012-05-07 11:30:00	AAPL	Stock	20.1218	20.1686	20.0796	20.1464	16930312.0
2012-05-07 12:00:00	AAPL	Stock	20.1438	20.1846	20.1264	20.1686	14964740.0
2012-05-07 12:30:00	AAPL	Stock	20.1686	20.3186	20.1686	20.2743	32340308.0
2012-05-07 13:00:00	AAPL	Stock	20.2736	20.35	20.2554	20.2961	17211068.0
2012-05-07 13:30:00	AAPL	Stock	20.2932	20.4071	20.2857	20.3911	27268808.0
2012-05-07 14:00:00	AAPL	Stock	20.3975	20.4339	20.3718	20.4	24222548.0
2012-05-07 14:30:00	AAPL	Stock	20.4007	20.4214	20.3396	20.4125	18293800.0
2012-05-07 15:00:00	AAPL	Stock	20.4132	20.4368	20.3571	20.3731	16645496.0
2012-05-07 15:30:00	AAPL	Stock	20.375	20.406	20.2925	20.3443	32046924.0
2012-05-07 16:00:00	AAPL	Stock	20.3386	20.3679	20.136	20.3504	4908176.0
2012-05-07 16:30:00	AAPL	Stock	20.3464	20.3876	20.3411	20.3446	320124.0
2012-05-07 17:00:00	AAPL	Stock	20.3468	20.3536	20.3443	20.3536	69916.0
2012-05-07 17:30:00	AAPL	Stock	20.3518	20.3518	20.3221	20.3221	159628.0
2012-05-07 18:00:00	AAPL	Stock	20.3229	20.3229	20.3036	20.3211	122724.0
2012-05-07 18:30:00	AAPL	Stock	20.3211	20.3339	20.3211	20.3339	51940.0
2012-05-07 19:00:00	AAPL	Stock	20.3311	20.3311	20.3264	20.3264	11648.0
2012-05-07 19:30:00	AAPL	Stock	20.3304	20.3554	20.3271	20.35	94724.0
2012-05-07 04:30:00	MSFT	Stock	30.66	30.66	30.66	30.66	200.0
2012-05-07 05:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	100.0
2012-05-07 06:30:00	MSFT	Stock	30.64	30.64	30.64	30.64	1950.0
2012-05-07 07:00:00	MSFT	Stock	30.7	30.74	30.7	30.74	500.0
2012-05-07 07:30:00	MSFT	Stock	30.73	30.73	30.72	30.72	4700.0
2012-05-07 08:00:00	MSFT	Stock	30.75	30.81	30.72	30.81	8200.0
2012-05-07 08:30:00	MSFT	Stock	30.83	30.83	30.75	30.79	21240.0
2012-05-07 09:00:00	MSFT	Stock	30.79	30.79	30.65	30.69	57457.0
2012-05-07 09:30:00	MSFT	Stock	30.69	30.72	30.57	30.67	6225413.0
2012-05-07 10:00:00	MSFT	Stock	30.66	30.74	30.63	30.66	3837682.0
2012-05-07 10:30:00	MSFT	Stock	30.655	30.85	30.61	30.78	3533864.0
2012-05-07 11:00:00	MSFT	Stock	30.785	30.84	30.69	30.705	2650191.0
2012-05-07 11:30:00	MSFT	Stock	30.71	30.79	30.71	30.76	1848279.0
2012-05-07 12:00:00	MSFT	Stock	30.76	30.79	30.73	30.74	1178197.0
2012-05-07 12:30:00	MSFT	Stock	30.745	30.81	30.725	30.76	1870274.0
2012-05-07 13:00:00	MSFT	Stock	30.76	30.83	30.76	30.795	1593152.0
2012-05-07 13:30:00	MSFT	Stock	30.795	30.86	30.78	30.821	1955267.0
2012-05-07 14:00:00	MSFT	Stock	30.83	30.86	30.77	30.785	2044326.0

> showing 50 of 75,888 rows — these rows as CSV

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