PREVIEW / stock_30min / 2012-01-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-11.parquet
  size:    1.4 MB
  rows:    75,618
  symbols: 3,561

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-01-11 04:00:00	AAPL	Stock	15.1071	15.1071	15.1071	15.1071	2800.0
2012-01-11 06:30:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	2800.0
2012-01-11 07:00:00	AAPL	Stock	15.0557	15.0714	15.0557	15.0714	53032.0
2012-01-11 07:30:00	AAPL	Stock	15.0718	15.1421	15.0714	15.1071	112000.0
2012-01-11 08:00:00	AAPL	Stock	15.1071	15.1086	15.0536	15.0621	528304.0
2012-01-11 08:30:00	AAPL	Stock	15.0682	15.0861	15.0604	15.0786	512876.0
2012-01-11 09:00:00	AAPL	Stock	15.0846	15.0979	15.0718	15.0821	434084.0
2012-01-11 09:30:00	AAPL	Stock	15.0957	15.0975	14.9893	15.0014	44296588.0
2012-01-11 10:00:00	AAPL	Stock	15.002	15.0607	14.9754	15.0418	27657280.0
2012-01-11 10:30:00	AAPL	Stock	15.0404	15.0804	15.03	15.0409	18279184.0
2012-01-11 11:00:00	AAPL	Stock	15.04	15.04	15.0039	15.0039	12098044.0
2012-01-11 11:30:00	AAPL	Stock	15.0046	15.05	15.0021	15.0329	10103044.0
2012-01-11 12:00:00	AAPL	Stock	15.0321	15.0429	15.0171	15.0204	6893544.0
2012-01-11 12:30:00	AAPL	Stock	15.0193	15.0325	15.0104	15.0221	9054164.0
2012-01-11 13:00:00	AAPL	Stock	15.0201	15.0389	15.0201	15.0375	5946444.0
2012-01-11 13:30:00	AAPL	Stock	15.0375	15.0643	15.0364	15.0386	10239600.0
2012-01-11 14:00:00	AAPL	Stock	15.0386	15.0571	15.0357	15.0475	7913584.0
2012-01-11 14:30:00	AAPL	Stock	15.0475	15.0668	15.0421	15.0489	7950432.0
2012-01-11 15:00:00	AAPL	Stock	15.0507	15.0714	15.0446	15.0704	13047020.0
2012-01-11 15:30:00	AAPL	Stock	15.07	15.1018	15.065	15.0911	28092288.0
2012-01-11 16:00:00	AAPL	Stock	15.0896	15.1071	15.042	15.1036	6749904.0
2012-01-11 16:30:00	AAPL	Stock	15.1018	15.1071	15.0681	15.0986	164668.0
2012-01-11 17:00:00	AAPL	Stock	15.0986	15.1018	15.0911	15.1018	117824.0
2012-01-11 17:30:00	AAPL	Stock	15.1039	15.1039	15.0911	15.0939	95312.0
2012-01-11 18:00:00	AAPL	Stock	15.1	15.1	15.0911	15.0964	30912.0
2012-01-11 18:30:00	AAPL	Stock	15.1	15.1071	15.1	15.105	31136.0
2012-01-11 19:00:00	AAPL	Stock	15.1068	15.1068	15.1	15.1018	37800.0
2012-01-11 19:30:00	AAPL	Stock	15.1021	15.1071	15.1004	15.1071	40768.0
2012-01-11 05:00:00	MSFT	Stock	27.6	27.62	27.6	27.62	500.0
2012-01-11 06:00:00	MSFT	Stock	27.55	27.55	27.55	27.55	500.0
2012-01-11 06:30:00	MSFT	Stock	27.52	27.56	27.52	27.56	1000.0
2012-01-11 07:00:00	MSFT	Stock	27.56	27.56	27.46	27.46	29464.0
2012-01-11 07:30:00	MSFT	Stock	27.46	27.54	27.43	27.54	50700.0
2012-01-11 08:00:00	MSFT	Stock	27.5	27.54	27.41	27.41	168365.0
2012-01-11 08:30:00	MSFT	Stock	27.41	27.51	27.38	27.45	150632.0
2012-01-11 09:00:00	MSFT	Stock	27.46	27.5	27.36	27.43	322612.0
2012-01-11 09:30:00	MSFT	Stock	27.43	27.72	27.37	27.5	10946235.0
2012-01-11 10:00:00	MSFT	Stock	27.5	27.9	27.47	27.835	6587616.0
2012-01-11 10:30:00	MSFT	Stock	27.83	27.91	27.75	27.89	4498901.0
2012-01-11 11:00:00	MSFT	Stock	27.89	27.91	27.85	27.87	5644165.0
2012-01-11 11:30:00	MSFT	Stock	27.865	27.91	27.84	27.86	3922716.0
2012-01-11 12:00:00	MSFT	Stock	27.859	27.876	27.79	27.834	4440371.0
2012-01-11 12:30:00	MSFT	Stock	27.84	27.85	27.8	27.84	2169694.0
2012-01-11 13:00:00	MSFT	Stock	27.835	27.93	27.83	27.885	4495682.0
2012-01-11 13:30:00	MSFT	Stock	27.882	27.96	27.87	27.89	3854655.0
2012-01-11 14:00:00	MSFT	Stock	27.883	27.97	27.88	27.929	3585253.0
2012-01-11 14:30:00	MSFT	Stock	27.924	27.97	27.92	27.942	1641809.0
2012-01-11 15:00:00	MSFT	Stock	27.94	27.955	27.9	27.92	2490208.0
2012-01-11 15:30:00	MSFT	Stock	27.93	27.93	27.72	27.72	7861536.0
2012-01-11 16:00:00	MSFT	Stock	27.73	27.92	27.62	27.869	1882923.0

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

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