PREVIEW / stock_30min / 2011-02-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-01.parquet
  size:    1.5 MB
  rows:    78,578
  symbols: 3,524

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-02-01 04:00:00	AAPL	Stock	12.1332	12.1696	12.1332	12.1536	25200.0
2011-02-01 04:30:00	AAPL	Stock	12.1607	12.1668	12.1404	12.1404	11200.0
2011-02-01 05:00:00	AAPL	Stock	12.1554	12.1554	12.1554	12.1554	2800.0
2011-02-01 05:30:00	AAPL	Stock	12.1529	12.1529	12.1529	12.1529	2800.0
2011-02-01 06:00:00	AAPL	Stock	12.16	12.16	12.1393	12.1393	8400.0
2011-02-01 06:30:00	AAPL	Stock	12.1696	12.1696	12.1696	12.1696	13300.0
2011-02-01 07:00:00	AAPL	Stock	12.1696	12.1764	12.1625	12.175	184772.0
2011-02-01 07:30:00	AAPL	Stock	12.1739	12.1775	12.1554	12.1625	98700.0
2011-02-01 08:00:00	AAPL	Stock	12.1582	12.1943	12.1186	12.1921	1146684.0
2011-02-01 08:30:00	AAPL	Stock	12.1921	12.1925	12.1186	12.175	700448.0
2011-02-01 09:00:00	AAPL	Stock	12.1768	12.1961	12.1186	12.1957	1215788.0
2011-02-01 09:30:00	AAPL	Stock	12.1893	12.2496	12.1779	12.2296	53843636.0
2011-02-01 10:00:00	AAPL	Stock	12.2277	12.2818	12.2	12.2733	44787288.0
2011-02-01 10:30:00	AAPL	Stock	12.2736	12.3036	12.2671	12.2975	35482692.0
2011-02-01 11:00:00	AAPL	Stock	12.2979	12.3168	12.275	12.2904	30840152.0
2011-02-01 11:30:00	AAPL	Stock	12.2904	12.3018	12.2757	12.29	19387228.0
2011-02-01 12:00:00	AAPL	Stock	12.29	12.325	12.29	12.3214	37468312.0
2011-02-01 12:30:00	AAPL	Stock	12.3218	12.33	12.3125	12.3282	24089828.0
2011-02-01 13:00:00	AAPL	Stock	12.3271	12.3304	12.3154	12.3257	17745224.0
2011-02-01 13:30:00	AAPL	Stock	12.3254	12.3271	12.3086	12.3104	17207064.0
2011-02-01 14:00:00	AAPL	Stock	12.31	12.3268	12.3093	12.3257	20278608.0
2011-02-01 14:30:00	AAPL	Stock	12.3264	12.3393	12.3143	12.3325	26240116.0
2011-02-01 15:00:00	AAPL	Stock	12.3329	12.3446	12.3186	12.3365	19676664.0
2011-02-01 15:30:00	AAPL	Stock	12.3363	12.3411	12.3143	12.3254	48584928.0
2011-02-01 16:00:00	AAPL	Stock	12.3225	12.3305	12.2944	12.3143	23221156.0
2011-02-01 16:30:00	AAPL	Stock	12.3157	12.3354	12.3043	12.3043	373408.0
2011-02-01 17:00:00	AAPL	Stock	12.3104	12.3164	12.3086	12.3125	137228.0
2011-02-01 17:30:00	AAPL	Stock	12.3129	12.3225	12.3118	12.3225	732144.0
2011-02-01 18:00:00	AAPL	Stock	12.3175	12.3225	12.3111	12.3143	183568.0
2011-02-01 18:30:00	AAPL	Stock	12.3143	12.3161	12.3143	12.3161	11200.0
2011-02-01 19:00:00	AAPL	Stock	12.3161	12.3179	12.3146	12.3179	55132.0
2011-02-01 19:30:00	AAPL	Stock	12.3143	12.3214	12.3143	12.3214	283752.0
2011-02-01 04:00:00	MSFT	Stock	27.72	27.72	27.65	27.65	2000.0
2011-02-01 05:30:00	MSFT	Stock	27.8	27.8	27.8	27.8	200.0
2011-02-01 06:30:00	MSFT	Stock	27.89	27.9	27.77	27.88	600.0
2011-02-01 07:00:00	MSFT	Stock	27.88	27.88	27.82	27.82	2800.0
2011-02-01 07:30:00	MSFT	Stock	27.85	27.85	27.82	27.85	1750.0
2011-02-01 08:00:00	MSFT	Stock	27.87	27.87	27.725	27.85	65840.0
2011-02-01 08:30:00	MSFT	Stock	27.83	27.84	27.725	27.8	12259.0
2011-02-01 09:00:00	MSFT	Stock	27.8	27.83	27.79	27.8	103006.0
2011-02-01 09:30:00	MSFT	Stock	27.8	27.82	27.61	27.66	6733486.0
2011-02-01 10:00:00	MSFT	Stock	27.65	27.79	27.64	27.78	5025431.0
2011-02-01 10:30:00	MSFT	Stock	27.773	27.8	27.71	27.8	5297925.0
2011-02-01 11:00:00	MSFT	Stock	27.8	27.805	27.75	27.781	4297871.0
2011-02-01 11:30:00	MSFT	Stock	27.79	27.85	27.78	27.801	3305505.0
2011-02-01 12:00:00	MSFT	Stock	27.8	27.99	27.77	27.975	4754640.0
2011-02-01 12:30:00	MSFT	Stock	27.97	28.02	27.9	28.0	4658751.0
2011-02-01 13:00:00	MSFT	Stock	28.0	28.02	27.88	27.902	3294425.0
2011-02-01 13:30:00	MSFT	Stock	27.905	27.99	27.86	27.96	2566394.0
2011-02-01 14:00:00	MSFT	Stock	27.96	27.98	27.92	27.925	2291123.0

> showing 50 of 78,578 rows — these rows as CSV

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