PREVIEW / stock_30min / 2012-12-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-17.parquet
  size:    1.5 MB
  rows:    78,119
  symbols: 3,516

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-12-17 04:00:00	AAPL	Stock	18.3929	18.3929	18.0179	18.0375	170520.0
2012-12-17 04:30:00	AAPL	Stock	18.0179	18.0429	17.9	17.9	150388.0
2012-12-17 05:00:00	AAPL	Stock	17.885	17.885	17.7875	17.8532	206780.0
2012-12-17 05:30:00	AAPL	Stock	17.8411	17.8571	17.825	17.8375	208852.0
2012-12-17 06:00:00	AAPL	Stock	17.8514	17.8514	17.7679	17.7854	463932.0
2012-12-17 06:30:00	AAPL	Stock	17.7746	17.8393	17.7389	17.8214	608020.0
2012-12-17 07:00:00	AAPL	Stock	17.8393	17.96	17.8214	17.9464	1266216.0
2012-12-17 07:30:00	AAPL	Stock	17.9557	18.0179	17.9107	18.0075	919100.0
2012-12-17 08:00:00	AAPL	Stock	18.0214	18.2407	17.7461	18.2179	5754392.0
2012-12-17 08:30:00	AAPL	Stock	18.2143	18.3329	18.2143	18.2436	6752760.0
2012-12-17 09:00:00	AAPL	Stock	18.2446	18.2486	18.1154	18.1764	6820800.0
2012-12-17 09:30:00	AAPL	Stock	18.1761	18.3696	18.0646	18.0768	144801468.0
2012-12-17 10:00:00	AAPL	Stock	18.0768	18.175	17.9011	18.0054	91753564.0
2012-12-17 10:30:00	AAPL	Stock	18.0068	18.1404	17.95	18.1057	61147688.0
2012-12-17 11:00:00	AAPL	Stock	18.105	18.1661	18.0593	18.0648	40470612.0
2012-12-17 11:30:00	AAPL	Stock	18.0654	18.36	18.0654	18.3507	66441088.0
2012-12-17 12:00:00	AAPL	Stock	18.3429	18.4464	18.2639	18.3982	50447572.0
2012-12-17 12:30:00	AAPL	Stock	18.3986	18.4643	18.3504	18.3946	33287408.0
2012-12-17 13:00:00	AAPL	Stock	18.3957	18.4643	18.3089	18.3474	31841600.0
2012-12-17 13:30:00	AAPL	Stock	18.3511	18.3811	18.2679	18.2821	30583420.0
2012-12-17 14:00:00	AAPL	Stock	18.2821	18.3536	18.22	18.2607	30532852.0
2012-12-17 14:30:00	AAPL	Stock	18.2595	18.3411	18.2568	18.3327	20648712.0
2012-12-17 15:00:00	AAPL	Stock	18.3386	18.3929	18.2857	18.3918	33889548.0
2012-12-17 15:30:00	AAPL	Stock	18.3907	18.5714	18.3671	18.5414	74885188.0
2012-12-17 16:00:00	AAPL	Stock	18.5418	18.5796	18.0536	18.5796	13697124.0
2012-12-17 16:30:00	AAPL	Stock	18.5768	18.58	18.5418	18.5679	984452.0
2012-12-17 17:00:00	AAPL	Stock	18.5679	18.5882	18.5611	18.5821	421764.0
2012-12-17 17:30:00	AAPL	Stock	18.5861	18.625	18.5861	18.6214	469168.0
2012-12-17 18:00:00	AAPL	Stock	18.6168	18.6339	18.5893	18.5946	325976.0
2012-12-17 18:30:00	AAPL	Stock	18.5946	18.5979	18.5786	18.5786	486892.0
2012-12-17 19:00:00	AAPL	Stock	18.5786	18.5893	18.5786	18.5807	213640.0
2012-12-17 19:30:00	AAPL	Stock	18.585	18.5989	18.5821	18.5893	703220.0
2012-12-17 05:00:00	MSFT	Stock	26.81	26.81	26.81	26.81	100.0
2012-12-17 07:30:00	MSFT	Stock	26.82	26.82	26.82	26.82	225.0
2012-12-17 08:00:00	MSFT	Stock	26.92	26.92	26.81	26.84	7200.0
2012-12-17 08:30:00	MSFT	Stock	26.84	26.84	26.79	26.79	36497.0
2012-12-17 09:00:00	MSFT	Stock	26.81	26.81	26.76	26.79	31184.0
2012-12-17 09:30:00	MSFT	Stock	26.79	27.04	26.68	27.005	4579135.0
2012-12-17 10:00:00	MSFT	Stock	27.005	27.11	26.7	27.0	3190240.0
2012-12-17 10:30:00	MSFT	Stock	26.99	27.02	26.95	26.975	2058468.0
2012-12-17 11:00:00	MSFT	Stock	26.975	27.1	26.97	27.03	2827607.0
2012-12-17 11:30:00	MSFT	Stock	27.02	27.17	27.0	27.13	2223005.0
2012-12-17 12:00:00	MSFT	Stock	27.13	27.215	27.11	27.168	1890671.0
2012-12-17 12:30:00	MSFT	Stock	27.16	27.17	27.06	27.06	1723006.0
2012-12-17 13:00:00	MSFT	Stock	27.065	27.09	27.02	27.02	1728428.0
2012-12-17 13:30:00	MSFT	Stock	27.02	27.03	26.94	26.95	1745984.0
2012-12-17 14:00:00	MSFT	Stock	26.95	26.985	26.87	26.89	2605366.0
2012-12-17 14:30:00	MSFT	Stock	26.89	26.93	26.84	26.87	2918258.0
2012-12-17 15:00:00	MSFT	Stock	26.87	26.96	26.85	26.935	2474802.0
2012-12-17 15:30:00	MSFT	Stock	26.935	27.1	26.92	27.1	5696307.0

> showing 50 of 78,119 rows — these rows as CSV

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