PREVIEW / stock_30min / 2012-06-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-01.parquet
  size:    1.5 MB
  rows:    79,421
  symbols: 3,534

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-06-01 04:00:00	AAPL	Stock	20.5536	20.5536	20.5464	20.5464	44800.0
2012-06-01 04:30:00	AAPL	Stock	20.5143	20.55	20.5143	20.5393	58800.0
2012-06-01 05:00:00	AAPL	Stock	20.5179	20.5179	20.4682	20.4821	49896.0
2012-06-01 05:30:00	AAPL	Stock	20.4682	20.4682	20.4643	20.4643	8400.0
2012-06-01 06:00:00	AAPL	Stock	20.4329	20.4329	20.4286	20.4289	28000.0
2012-06-01 06:30:00	AAPL	Stock	20.4607	20.4607	20.4286	20.4357	11200.0
2012-06-01 07:00:00	AAPL	Stock	20.4357	20.4739	20.4018	20.4643	213388.0
2012-06-01 07:30:00	AAPL	Stock	20.4625	20.4643	20.4357	20.4511	162988.0
2012-06-01 08:00:00	AAPL	Stock	20.4268	20.4867	20.4107	20.4639	1096060.0
2012-06-01 08:30:00	AAPL	Stock	20.4536	20.4554	20.2911	20.3532	5496988.0
2012-06-01 09:00:00	AAPL	Stock	20.3536	20.3689	20.2575	20.3254	5543328.0
2012-06-01 09:30:00	AAPL	Stock	20.3214	20.4071	20.2857	20.3636	69569136.0
2012-06-01 10:00:00	AAPL	Stock	20.3721	20.4518	20.3314	20.3561	50286432.0
2012-06-01 10:30:00	AAPL	Stock	20.3546	20.3607	20.2882	20.3229	35952056.0
2012-06-01 11:00:00	AAPL	Stock	20.3236	20.33	20.2632	20.2989	27475308.0
2012-06-01 11:30:00	AAPL	Stock	20.2989	20.3089	20.2021	20.2266	31574060.0
2012-06-01 12:00:00	AAPL	Stock	20.2266	20.2811	20.2171	20.2471	23469236.0
2012-06-01 12:30:00	AAPL	Stock	20.2464	20.2554	20.2143	20.2214	16017540.0
2012-06-01 13:00:00	AAPL	Stock	20.2214	20.2314	20.1607	20.1607	26092556.0
2012-06-01 13:30:00	AAPL	Stock	20.1621	20.1696	20.1	20.1468	32019344.0
2012-06-01 14:00:00	AAPL	Stock	20.1493	20.1494	20.0186	20.0911	43572704.0
2012-06-01 14:30:00	AAPL	Stock	20.0904	20.1511	20.0607	20.0911	29950088.0
2012-06-01 15:00:00	AAPL	Stock	20.0929	20.1379	20.0536	20.065	32167128.0
2012-06-01 15:30:00	AAPL	Stock	20.0679	20.0918	20.0196	20.0379	63827400.0
2012-06-01 16:00:00	AAPL	Stock	20.0375	20.2118	20.0314	20.0475	16198812.0
2012-06-01 16:30:00	AAPL	Stock	20.0471	20.0694	20.0314	20.0396	1135344.0
2012-06-01 17:00:00	AAPL	Stock	20.0464	20.0643	20.0354	20.0589	745220.0
2012-06-01 17:30:00	AAPL	Stock	20.0571	20.0571	20.0461	20.0511	260484.0
2012-06-01 18:00:00	AAPL	Stock	20.0518	20.0536	20.04	20.0411	102340.0
2012-06-01 18:30:00	AAPL	Stock	20.0446	20.0454	20.0407	20.0407	27888.0
2012-06-01 19:00:00	AAPL	Stock	20.0407	20.05	20.0361	20.05	109564.0
2012-06-01 19:30:00	AAPL	Stock	20.0496	20.0496	20.04	20.04	157500.0
2012-06-01 05:30:00	MSFT	Stock	29.0	29.0	29.0	29.0	100.0
2012-06-01 06:00:00	MSFT	Stock	28.92	28.92	28.92	28.92	1000.0
2012-06-01 07:30:00	MSFT	Stock	28.95	28.95	28.95	28.95	100.0
2012-06-01 08:00:00	MSFT	Stock	29.0	29.01	28.9	28.9	68497.0
2012-06-01 08:30:00	MSFT	Stock	28.9	28.9	28.51	28.76	53336.0
2012-06-01 09:00:00	MSFT	Stock	28.72	28.81	28.72	28.78	30060.0
2012-06-01 09:30:00	MSFT	Stock	28.8	28.96	28.64	28.84	6194330.0
2012-06-01 10:00:00	MSFT	Stock	28.83	28.93	28.65	28.65	4164115.0
2012-06-01 10:30:00	MSFT	Stock	28.655	28.83	28.59	28.685	2653987.0
2012-06-01 11:00:00	MSFT	Stock	28.69	28.78	28.63	28.73	2990101.0
2012-06-01 11:30:00	MSFT	Stock	28.725	28.75	28.65	28.705	2445864.0
2012-06-01 12:00:00	MSFT	Stock	28.7	28.79	28.67	28.705	1889234.0
2012-06-01 12:30:00	MSFT	Stock	28.705	28.73	28.62	28.62	2144424.0
2012-06-01 13:00:00	MSFT	Stock	28.625	28.7	28.6	28.638	2836843.0
2012-06-01 13:30:00	MSFT	Stock	28.63	28.64	28.52	28.56	3526820.0
2012-06-01 14:00:00	MSFT	Stock	28.56	28.65	28.55	28.59	3519294.0
2012-06-01 14:30:00	MSFT	Stock	28.58	28.66	28.55	28.585	2788280.0
2012-06-01 15:00:00	MSFT	Stock	28.58	28.67	28.52	28.57	3571659.0

> showing 50 of 79,421 rows — these rows as CSV

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