PREVIEW / stock_30min / 2014-10-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-06.parquet
  size:    1.6 MB
  rows:    82,870
  symbols: 3,558

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
2014-10-06 04:00:00	AAPL	Stock	24.905	25.025	24.905	25.025	12500.0
2014-10-06 04:30:00	AAPL	Stock	25.025	25.0375	25.025	25.0375	3600.0
2014-10-06 05:00:00	AAPL	Stock	25.03	25.04	25.005	25.005	3600.0
2014-10-06 05:30:00	AAPL	Stock	24.9925	25.0	24.975	25.0	4716.0
2014-10-06 06:00:00	AAPL	Stock	24.995	24.995	24.975	24.975	2716.0
2014-10-06 06:30:00	AAPL	Stock	25.0	25.0	24.9825	24.9825	18000.0
2014-10-06 07:00:00	AAPL	Stock	24.995	25.0	24.95	24.995	31168.0
2014-10-06 07:30:00	AAPL	Stock	24.995	25.0475	24.9925	25.025	106792.0
2014-10-06 08:00:00	AAPL	Stock	25.0	25.0475	24.9775	25.0375	335680.0
2014-10-06 08:30:00	AAPL	Stock	25.04	25.055	25.015	25.015	171060.0
2014-10-06 09:00:00	AAPL	Stock	25.0175	25.0325	24.9475	24.9875	321712.0
2014-10-06 09:30:00	AAPL	Stock	24.9875	25.1625	24.955	25.1312	24144432.0
2014-10-06 10:00:00	AAPL	Stock	25.1318	25.1575	25.0162	25.074	16377600.0
2014-10-06 10:30:00	AAPL	Stock	25.074	25.125	24.9875	25.0425	11911412.0
2014-10-06 11:00:00	AAPL	Stock	25.0425	25.0625	24.99	25.0075	7076900.0
2014-10-06 11:30:00	AAPL	Stock	25.0075	25.0532	24.89	24.9525	11534660.0
2014-10-06 12:00:00	AAPL	Stock	24.9513	25.0	24.92	24.9425	6255796.0
2014-10-06 12:30:00	AAPL	Stock	24.9425	24.95	24.8825	24.9175	6848104.0
2014-10-06 13:00:00	AAPL	Stock	24.915	25.0	24.896	24.9938	5603760.0
2014-10-06 13:30:00	AAPL	Stock	24.9925	25.021	24.905	24.97	7764800.0
2014-10-06 14:00:00	AAPL	Stock	24.9725	24.9975	24.912	24.985	8162596.0
2014-10-06 14:30:00	AAPL	Stock	24.9825	24.9975	24.9418	24.9425	5519692.0
2014-10-06 15:00:00	AAPL	Stock	24.9402	24.96	24.9	24.93	9332500.0
2014-10-06 15:30:00	AAPL	Stock	24.93	24.9325	24.855	24.9062	13992084.0
2014-10-06 16:00:00	AAPL	Stock	24.905	25.0552	24.825	24.825	3995056.0
2014-10-06 16:30:00	AAPL	Stock	24.825	24.9445	24.7975	24.835	164452.0
2014-10-06 17:00:00	AAPL	Stock	24.8325	24.905	24.8325	24.85	106104.0
2014-10-06 17:30:00	AAPL	Stock	24.905	24.905	24.84	24.8625	737472.0
2014-10-06 18:00:00	AAPL	Stock	24.85	24.905	24.85	24.8575	38704.0
2014-10-06 18:30:00	AAPL	Stock	24.8625	24.905	24.855	24.905	184176.0
2014-10-06 19:00:00	AAPL	Stock	24.8525	24.8525	24.8225	24.8475	45048.0
2014-10-06 19:30:00	AAPL	Stock	24.8425	24.905	24.8325	24.8575	65884.0
2014-10-06 07:30:00	MSFT	Stock	46.19	46.31	46.19	46.31	300.0
2014-10-06 08:00:00	MSFT	Stock	46.22	46.22	45.54	46.2	5837.0
2014-10-06 08:30:00	MSFT	Stock	46.2	46.2	46.12	46.12	2872.0
2014-10-06 09:00:00	MSFT	Stock	46.18	46.18	46.07	46.12	57880.0
2014-10-06 09:30:00	MSFT	Stock	46.12	46.3	45.92	46.24	2762743.0
2014-10-06 10:00:00	MSFT	Stock	46.25	46.3	46.15	46.18	2040523.0
2014-10-06 10:30:00	MSFT	Stock	46.18	46.236	46.09	46.14	1493711.0
2014-10-06 11:00:00	MSFT	Stock	46.14	46.25	46.13	46.175	1400893.0
2014-10-06 11:30:00	MSFT	Stock	46.18	46.24	45.965	46.02	1865696.0
2014-10-06 12:00:00	MSFT	Stock	46.02	46.08	45.99	46.045	764822.0
2014-10-06 12:30:00	MSFT	Stock	46.04	46.06	45.96	46.01	1071415.0
2014-10-06 13:00:00	MSFT	Stock	46.0	46.1	45.95	46.095	786947.0
2014-10-06 13:30:00	MSFT	Stock	46.1	46.12	46.05	46.08	810764.0
2014-10-06 14:00:00	MSFT	Stock	46.085	46.14	46.03	46.12	1008460.0
2014-10-06 14:30:00	MSFT	Stock	46.12	46.16	46.08	46.09	928713.0
2014-10-06 15:00:00	MSFT	Stock	46.09	46.17	46.015	46.12	1593213.0
2014-10-06 15:30:00	MSFT	Stock	46.12	46.14	46.07	46.1	2228831.0
2014-10-06 16:00:00	MSFT	Stock	46.09	46.173	46.06	46.1	904232.0

> showing 50 of 82,870 rows — these rows as CSV

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