PREVIEW / stock_30min / 2012-10-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-05.parquet
  size:    1.4 MB
  rows:    74,641
  symbols: 3,457

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-10-05 04:30:00	AAPL	Stock	23.7857	23.7857	23.7857	23.7857	11200.0
2012-10-05 06:30:00	AAPL	Stock	23.8132	23.8132	23.8036	23.8036	26600.0
2012-10-05 07:00:00	AAPL	Stock	23.7961	23.7964	23.7679	23.7889	185052.0
2012-10-05 07:30:00	AAPL	Stock	23.7857	23.8075	23.7857	23.8032	188300.0
2012-10-05 08:00:00	AAPL	Stock	23.8018	23.8089	23.7339	23.7571	553028.0
2012-10-05 08:30:00	AAPL	Stock	23.7754	23.8571	23.7693	23.8061	2701020.0
2012-10-05 09:00:00	AAPL	Stock	23.8064	23.8429	23.7143	23.7486	2633064.0
2012-10-05 09:30:00	AAPL	Stock	23.7561	23.7857	23.665	23.7504	64446088.0
2012-10-05 10:00:00	AAPL	Stock	23.7479	23.7761	23.6904	23.7136	31194996.0
2012-10-05 10:30:00	AAPL	Stock	23.7118	23.7446	23.55	23.5536	49094080.0
2012-10-05 11:00:00	AAPL	Stock	23.5561	23.6029	23.515	23.543	37278248.0
2012-10-05 11:30:00	AAPL	Stock	23.5407	23.5625	23.4414	23.4589	43164352.0
2012-10-05 12:00:00	AAPL	Stock	23.4593	23.4643	23.3132	23.355	61494328.0
2012-10-05 12:30:00	AAPL	Stock	23.3546	23.5529	23.3539	23.5259	42035728.0
2012-10-05 13:00:00	AAPL	Stock	23.5257	23.5857	23.4144	23.4365	29346604.0
2012-10-05 13:30:00	AAPL	Stock	23.4361	23.5461	23.4007	23.5282	30836988.0
2012-10-05 14:00:00	AAPL	Stock	23.5284	23.5284	23.425	23.4711	22253588.0
2012-10-05 14:30:00	AAPL	Stock	23.4711	23.4936	23.3304	23.3521	30931040.0
2012-10-05 15:00:00	AAPL	Stock	23.3504	23.4093	23.3214	23.3496	42470288.0
2012-10-05 15:30:00	AAPL	Stock	23.345	23.3543	23.26	23.3064	72745372.0
2012-10-05 16:00:00	AAPL	Stock	23.3089	23.494	23.2964	23.3286	13387920.0
2012-10-05 16:30:00	AAPL	Stock	23.3246	23.6255	23.3057	23.3143	655480.0
2012-10-05 17:00:00	AAPL	Stock	23.3068	23.3107	23.2789	23.2821	1142736.0
2012-10-05 17:30:00	AAPL	Stock	23.2821	23.2979	23.2732	23.2732	352968.0
2012-10-05 18:00:00	AAPL	Stock	23.2732	23.2779	23.2589	23.2668	120484.0
2012-10-05 18:30:00	AAPL	Stock	23.2589	23.2643	23.25	23.25	168364.0
2012-10-05 19:00:00	AAPL	Stock	23.2561	23.2589	23.2511	23.2589	103320.0
2012-10-05 19:30:00	AAPL	Stock	23.265	23.2893	23.2625	23.2893	230524.0
2012-10-05 08:00:00	MSFT	Stock	30.0	30.05	30.0	30.03	4165.0
2012-10-05 08:30:00	MSFT	Stock	30.08	30.17	30.04	30.17	23878.0
2012-10-05 09:00:00	MSFT	Stock	30.15	30.25	30.15	30.21	75930.0
2012-10-05 09:30:00	MSFT	Stock	30.22	30.25	29.93	29.992	6041395.0
2012-10-05 10:00:00	MSFT	Stock	30.0	30.07	29.98	30.058	4052801.0
2012-10-05 10:30:00	MSFT	Stock	30.054	30.1	29.91	29.934	3313466.0
2012-10-05 11:00:00	MSFT	Stock	29.935	29.99	29.9	29.99	1964352.0
2012-10-05 11:30:00	MSFT	Stock	29.99	30.02	29.94	29.98	1976885.0
2012-10-05 12:00:00	MSFT	Stock	29.98	30.01	29.94	30.008	1199255.0
2012-10-05 12:30:00	MSFT	Stock	30.01	30.03	29.98	30.016	1337189.0
2012-10-05 13:00:00	MSFT	Stock	30.02	30.05	29.98	29.985	1061072.0
2012-10-05 13:30:00	MSFT	Stock	29.98	30.01	29.93	29.962	1898009.0
2012-10-05 14:00:00	MSFT	Stock	29.965	30.0	29.94	29.948	1357055.0
2012-10-05 14:30:00	MSFT	Stock	29.945	29.95	29.81	29.815	2121937.0
2012-10-05 15:00:00	MSFT	Stock	29.81	29.85	29.74	29.825	3433637.0
2012-10-05 15:30:00	MSFT	Stock	29.825	29.85	29.75	29.84	6633061.0
2012-10-05 16:00:00	MSFT	Stock	29.85	29.94	29.84	29.9	3152220.0
2012-10-05 16:30:00	MSFT	Stock	29.85	29.88	29.83	29.88	104185.0
2012-10-05 17:00:00	MSFT	Stock	29.86	29.86	29.86	29.86	500.0
2012-10-05 17:30:00	MSFT	Stock	29.86	29.9	29.86	29.9	1678.0
2012-10-05 19:30:00	MSFT	Stock	29.87	29.87	29.86	29.86	1650.0
2012-10-05 07:00:00	NVDA	Stock	0.3488	0.3488	0.3488	0.3488	12000.0

> showing 50 of 74,641 rows — these rows as CSV

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