PREVIEW / stock_30min / 2011-01-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-05.parquet
  size:    1.5 MB
  rows:    77,818
  symbols: 3,528

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-01-05 04:00:00	AAPL	Stock	11.5714	11.8161	11.5714	11.8125	8400.0
2011-01-05 05:00:00	AAPL	Stock	11.7886	11.7886	11.7886	11.7886	2800.0
2011-01-05 05:30:00	AAPL	Stock	11.7929	11.8	11.7929	11.8	30800.0
2011-01-05 06:00:00	AAPL	Stock	11.7929	11.7929	11.7907	11.7907	19600.0
2011-01-05 06:30:00	AAPL	Stock	11.7746	11.7839	11.7746	11.7839	5600.0
2011-01-05 07:00:00	AAPL	Stock	11.7618	11.7757	11.7543	11.7543	102200.0
2011-01-05 07:30:00	AAPL	Stock	11.7543	11.7643	11.75	11.7625	109200.0
2011-01-05 08:00:00	AAPL	Stock	11.7536	11.8189	11.7532	11.7946	2691948.0
2011-01-05 08:30:00	AAPL	Stock	11.7896	11.7993	11.775	11.7893	1063860.0
2011-01-05 09:00:00	AAPL	Stock	11.7932	11.8054	11.765	11.7661	949228.0
2011-01-05 09:30:00	AAPL	Stock	11.7661	11.8429	11.7661	11.8304	41292832.0
2011-01-05 10:00:00	AAPL	Stock	11.8279	11.8654	11.8164	11.8507	29001308.0
2011-01-05 10:30:00	AAPL	Stock	11.8511	11.8746	11.8486	11.8663	15443736.0
2011-01-05 11:00:00	AAPL	Stock	11.8661	11.8889	11.8614	11.8836	18172616.0
2011-01-05 11:30:00	AAPL	Stock	11.8861	11.8989	11.8829	11.8889	17208940.0
2011-01-05 12:00:00	AAPL	Stock	11.8889	11.9193	11.8839	11.9189	18044628.0
2011-01-05 12:30:00	AAPL	Stock	11.9193	11.9375	11.9171	11.9341	15550640.0
2011-01-05 13:00:00	AAPL	Stock	11.9339	11.9393	11.9156	11.9351	11972044.0
2011-01-05 13:30:00	AAPL	Stock	11.9343	11.9375	11.9182	11.9368	10109988.0
2011-01-05 14:00:00	AAPL	Stock	11.9365	11.9365	11.9114	11.9218	12477192.0
2011-01-05 14:30:00	AAPL	Stock	11.9229	11.9311	11.9107	11.9286	9686376.0
2011-01-05 15:00:00	AAPL	Stock	11.9286	11.9407	11.9243	11.9293	15638084.0
2011-01-05 15:30:00	AAPL	Stock	11.9289	11.935	11.915	11.9286	26515272.0
2011-01-05 16:00:00	AAPL	Stock	11.9286	11.9336	11.8861	11.9336	5173028.0
2011-01-05 16:30:00	AAPL	Stock	11.9293	11.9343	11.7605	11.9311	550004.0
2011-01-05 17:00:00	AAPL	Stock	11.9307	11.9589	11.9307	11.9586	393232.0
2011-01-05 17:30:00	AAPL	Stock	11.9525	11.9571	11.9421	11.9482	307244.0
2011-01-05 18:00:00	AAPL	Stock	11.9536	11.9586	11.9286	11.9471	278880.0
2011-01-05 18:30:00	AAPL	Stock	11.9568	11.9571	11.9518	11.9518	72716.0
2011-01-05 19:00:00	AAPL	Stock	11.9536	11.9536	11.9496	11.9496	110852.0
2011-01-05 19:30:00	AAPL	Stock	11.95	11.9571	11.95	11.9571	231812.0
2011-01-05 04:00:00	MSFT	Stock	28.02	28.02	28.02	28.02	400.0
2011-01-05 07:00:00	MSFT	Stock	27.82	27.82	27.82	27.82	600.0
2011-01-05 07:30:00	MSFT	Stock	27.82	27.82	27.82	27.82	300.0
2011-01-05 08:00:00	MSFT	Stock	27.85	28.02	27.85	28.02	17805.0
2011-01-05 08:30:00	MSFT	Stock	28.01	28.04	28.0	28.0	10128.0
2011-01-05 09:00:00	MSFT	Stock	28.0	28.04	27.9	27.91	154443.0
2011-01-05 09:30:00	MSFT	Stock	27.91	27.975	27.81	27.859	8853793.0
2011-01-05 10:00:00	MSFT	Stock	27.855	27.91	27.77	27.77	5339115.0
2011-01-05 10:30:00	MSFT	Stock	27.77	27.87	27.77	27.837	3593019.0
2011-01-05 11:00:00	MSFT	Stock	27.84	27.91	27.83	27.872	3348950.0
2011-01-05 11:30:00	MSFT	Stock	27.88	27.91	27.8	27.82	3097083.0
2011-01-05 12:00:00	MSFT	Stock	27.83	27.9	27.82	27.88	3473600.0
2011-01-05 12:30:00	MSFT	Stock	27.88	27.89	27.83	27.855	2533958.0
2011-01-05 13:00:00	MSFT	Stock	27.86	27.88	27.78	27.85	3338916.0
2011-01-05 13:30:00	MSFT	Stock	27.856	27.89	27.81	27.88	3393128.0
2011-01-05 14:00:00	MSFT	Stock	27.89	27.94	27.87	27.91	4292580.0
2011-01-05 14:30:00	MSFT	Stock	27.91	27.97	27.89	27.965	4516576.0
2011-01-05 15:00:00	MSFT	Stock	27.96	28.0	27.96	27.98	3014686.0
2011-01-05 15:30:00	MSFT	Stock	27.97	28.01	27.96	28.0	5774796.0

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

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