PREVIEW / stock_30min / 2011-12-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-19.parquet
  size:    1.4 MB
  rows:    77,085
  symbols: 3,535

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-12-19 05:30:00	AAPL	Stock	13.6571	13.6571	13.6507	13.6507	8400.0
2011-12-19 06:30:00	AAPL	Stock	13.6557	13.6557	13.6557	13.6557	2800.0
2011-12-19 07:00:00	AAPL	Stock	13.6786	13.6786	13.6429	13.6607	102284.0
2011-12-19 07:30:00	AAPL	Stock	13.6675	13.6782	13.6479	13.6518	130480.0
2011-12-19 08:00:00	AAPL	Stock	13.6457	13.6589	13.625	13.6589	370636.0
2011-12-19 08:30:00	AAPL	Stock	13.6571	13.6675	13.6432	13.6571	375424.0
2011-12-19 09:00:00	AAPL	Stock	13.6607	13.6607	13.6454	13.6593	318864.0
2011-12-19 09:30:00	AAPL	Stock	13.6593	13.7446	13.6593	13.7405	34791288.0
2011-12-19 10:00:00	AAPL	Stock	13.7407	13.7425	13.6861	13.705	18941832.0
2011-12-19 10:30:00	AAPL	Stock	13.7057	13.723	13.6754	13.6875	16809856.0
2011-12-19 11:00:00	AAPL	Stock	13.6846	13.6957	13.6532	13.6893	20567344.0
2011-12-19 11:30:00	AAPL	Stock	13.69	13.6932	13.6257	13.6636	14508564.0
2011-12-19 12:00:00	AAPL	Stock	13.6639	13.6964	13.6578	13.6882	8715588.0
2011-12-19 12:30:00	AAPL	Stock	13.6868	13.6993	13.6646	13.6954	6744332.0
2011-12-19 13:00:00	AAPL	Stock	13.6954	13.7132	13.6821	13.6882	9872520.0
2011-12-19 13:30:00	AAPL	Stock	13.6918	13.7268	13.6693	13.7129	11627924.0
2011-12-19 14:00:00	AAPL	Stock	13.7132	13.7168	13.6768	13.6779	7834848.0
2011-12-19 14:30:00	AAPL	Stock	13.6792	13.694	13.6621	13.6796	8303960.0
2011-12-19 15:00:00	AAPL	Stock	13.6795	13.6854	13.5886	13.6029	24640980.0
2011-12-19 15:30:00	AAPL	Stock	13.6025	13.6689	13.5921	13.6382	26769820.0
2011-12-19 16:00:00	AAPL	Stock	13.6482	13.6804	13.6396	13.6575	17472056.0
2011-12-19 16:30:00	AAPL	Stock	13.6639	13.6775	13.6504	13.6775	1290856.0
2011-12-19 17:00:00	AAPL	Stock	13.6714	13.6964	13.6504	13.6857	817964.0
2011-12-19 17:30:00	AAPL	Stock	13.6807	13.6807	13.6536	13.6607	414904.0
2011-12-19 18:00:00	AAPL	Stock	13.6661	13.6825	13.6504	13.6825	116732.0
2011-12-19 18:30:00	AAPL	Stock	13.6843	13.6907	13.6836	13.6904	255920.0
2011-12-19 19:00:00	AAPL	Stock	13.6907	13.7025	13.6893	13.6939	166796.0
2011-12-19 19:30:00	AAPL	Stock	13.7018	13.7143	13.6971	13.7093	231952.0
2011-12-19 04:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	100.0
2011-12-19 04:30:00	MSFT	Stock	26.01	26.01	26.01	26.01	100.0
2011-12-19 07:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	7400.0
2011-12-19 07:30:00	MSFT	Stock	26.06	26.07	26.06	26.07	1000.0
2011-12-19 08:00:00	MSFT	Stock	26.06	26.06	26.02	26.02	6000.0
2011-12-19 08:30:00	MSFT	Stock	26.05	26.06	26.0	26.0	25450.0
2011-12-19 09:00:00	MSFT	Stock	25.99	26.04	25.98	26.02	12965.0
2011-12-19 09:30:00	MSFT	Stock	26.0	26.12	25.89	25.9	4953674.0
2011-12-19 10:00:00	MSFT	Stock	25.9	25.92	25.84	25.91	4023850.0
2011-12-19 10:30:00	MSFT	Stock	25.905	25.91	25.78	25.81	3404873.0
2011-12-19 11:00:00	MSFT	Stock	25.8	25.82	25.75	25.81	2654440.0
2011-12-19 11:30:00	MSFT	Stock	25.81	25.82	25.74	25.8	2589484.0
2011-12-19 12:00:00	MSFT	Stock	25.79	25.84	25.79	25.83	2069863.0
2011-12-19 12:30:00	MSFT	Stock	25.83	25.83	25.76	25.8	2172486.0
2011-12-19 13:00:00	MSFT	Stock	25.8	25.8	25.76	25.77	1161724.0
2011-12-19 13:30:00	MSFT	Stock	25.77	25.8	25.72	25.758	4154126.0
2011-12-19 14:00:00	MSFT	Stock	25.76	25.76	25.65	25.685	1667929.0
2011-12-19 14:30:00	MSFT	Stock	25.685	25.7	25.62	25.695	1716927.0
2011-12-19 15:00:00	MSFT	Stock	25.7	25.7	25.46	25.48	5221361.0
2011-12-19 15:30:00	MSFT	Stock	25.48	25.56	25.46	25.52	9570353.0
2011-12-19 16:00:00	MSFT	Stock	25.52	25.825	25.5	25.515	4665086.0
2011-12-19 16:30:00	MSFT	Stock	25.52	25.996	25.505	25.59	418564.0

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

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