PREVIEW / stock_30min / 2012-03-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-20.parquet
  size:    1.4 MB
  rows:    77,244
  symbols: 3,541

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-03-20 04:00:00	AAPL	Stock	21.6225	21.6286	21.5696	21.5821	177156.0
2012-03-20 04:30:00	AAPL	Stock	21.5964	21.5964	21.5843	21.5925	70000.0
2012-03-20 05:00:00	AAPL	Stock	21.5893	21.5964	21.5696	21.5875	121576.0
2012-03-20 05:30:00	AAPL	Stock	21.5696	21.5696	21.5107	21.5179	67200.0
2012-03-20 06:00:00	AAPL	Stock	21.5057	21.5057	21.4646	21.4914	67872.0
2012-03-20 06:30:00	AAPL	Stock	21.4707	21.4707	21.3786	21.3929	196420.0
2012-03-20 07:00:00	AAPL	Stock	21.4107	21.4857	21.4107	21.47	904260.0
2012-03-20 07:30:00	AAPL	Stock	21.4711	21.4711	21.3682	21.3682	967568.0
2012-03-20 08:00:00	AAPL	Stock	21.375	21.4554	21.3071	21.4025	5620188.0
2012-03-20 08:30:00	AAPL	Stock	21.4018	21.4057	21.3621	21.3686	2354464.0
2012-03-20 09:00:00	AAPL	Stock	21.3671	21.4246	21.3304	21.4107	6127856.0
2012-03-20 09:30:00	AAPL	Stock	21.4107	21.4196	20.7857	21.2207	123115244.0
2012-03-20 10:00:00	AAPL	Stock	21.2204	21.3214	21.1243	21.305	71126804.0
2012-03-20 10:30:00	AAPL	Stock	21.3005	21.3464	21.25	21.2904	51920932.0
2012-03-20 11:00:00	AAPL	Stock	21.2886	21.3268	21.2357	21.2866	45765664.0
2012-03-20 11:30:00	AAPL	Stock	21.2854	21.3143	21.2464	21.3054	31978016.0
2012-03-20 12:00:00	AAPL	Stock	21.3015	21.3571	21.2786	21.3271	26971196.0
2012-03-20 12:30:00	AAPL	Stock	21.3279	21.3839	21.3125	21.3629	22761676.0
2012-03-20 13:00:00	AAPL	Stock	21.3629	21.4461	21.3571	21.4189	47165552.0
2012-03-20 13:30:00	AAPL	Stock	21.4186	21.5571	21.3704	21.5175	60698288.0
2012-03-20 14:00:00	AAPL	Stock	21.5179	21.5536	21.4643	21.5271	45520104.0
2012-03-20 14:30:00	AAPL	Stock	21.5296	21.5335	21.4464	21.5196	55262256.0
2012-03-20 15:00:00	AAPL	Stock	21.5193	21.675	21.5179	21.6257	83013392.0
2012-03-20 15:30:00	AAPL	Stock	21.6304	21.6536	21.5604	21.6414	74619160.0
2012-03-20 16:00:00	AAPL	Stock	21.6414	21.6489	21.4173	21.6393	21096516.0
2012-03-20 16:30:00	AAPL	Stock	21.6393	21.6414	21.6161	21.6161	2055984.0
2012-03-20 17:00:00	AAPL	Stock	21.6132	21.6414	21.321	21.6414	2233252.0
2012-03-20 17:30:00	AAPL	Stock	21.6414	21.6464	21.6336	21.6429	862736.0
2012-03-20 18:00:00	AAPL	Stock	21.6425	21.6425	21.6289	21.6289	261576.0
2012-03-20 18:30:00	AAPL	Stock	21.6289	21.6314	21.6186	21.6207	247968.0
2012-03-20 19:00:00	AAPL	Stock	21.6207	21.625	21.6068	21.6179	349132.0
2012-03-20 19:30:00	AAPL	Stock	21.6214	21.6214	21.5725	21.6071	808920.0
2012-03-20 07:00:00	MSFT	Stock	32.05	32.07	32.05	32.07	2800.0
2012-03-20 07:30:00	MSFT	Stock	32.07	32.07	32.05	32.05	2500.0
2012-03-20 08:00:00	MSFT	Stock	32.04	32.13	32.04	32.07	4693.0
2012-03-20 08:30:00	MSFT	Stock	32.07	32.1	32.07	32.09	29500.0
2012-03-20 09:00:00	MSFT	Stock	32.07	32.17	32.07	32.1	37711.0
2012-03-20 09:30:00	MSFT	Stock	32.09	32.15	31.79	31.89	6011344.0
2012-03-20 10:00:00	MSFT	Stock	31.895	31.97	31.82	31.855	4093552.0
2012-03-20 10:30:00	MSFT	Stock	31.855	31.9	31.83	31.85	2479328.0
2012-03-20 11:00:00	MSFT	Stock	31.85	31.97	31.84	31.91	3314480.0
2012-03-20 11:30:00	MSFT	Stock	31.91	32.12	31.8	31.875	2560717.0
2012-03-20 12:00:00	MSFT	Stock	31.872	31.91	31.8	31.805	2557815.0
2012-03-20 12:30:00	MSFT	Stock	31.8	31.82	31.74	31.82	1588974.0
2012-03-20 13:00:00	MSFT	Stock	31.82	31.88	31.78	31.815	2615147.0
2012-03-20 13:30:00	MSFT	Stock	31.82	31.84	31.76	31.81	2271301.0
2012-03-20 14:00:00	MSFT	Stock	31.81	31.92	31.8	31.854	1889799.0
2012-03-20 14:30:00	MSFT	Stock	31.86	31.88	31.84	31.865	1789422.0
2012-03-20 15:00:00	MSFT	Stock	31.87	31.94	31.86	31.86	2507519.0
2012-03-20 15:30:00	MSFT	Stock	31.865	31.99	31.86	31.99	5114283.0

> showing 50 of 77,244 rows — these rows as CSV

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