PREVIEW / stock_30min / 2014-01-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-10.parquet
  size:    1.6 MB
  rows:    81,479
  symbols: 3,521

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-01-10 04:00:00	AAPL	Stock	19.1957	19.2054	19.175	19.2054	17220.0
2014-01-10 04:30:00	AAPL	Stock	19.2054	19.2054	19.2054	19.2054	11900.0
2014-01-10 05:30:00	AAPL	Stock	19.25	19.2579	19.2464	19.2464	14000.0
2014-01-10 06:00:00	AAPL	Stock	19.25	19.2575	19.2464	19.2575	16800.0
2014-01-10 06:30:00	AAPL	Stock	19.2575	19.2575	19.2407	19.2407	30100.0
2014-01-10 07:00:00	AAPL	Stock	19.2532	19.2532	19.2364	19.2364	42000.0
2014-01-10 07:30:00	AAPL	Stock	19.25	19.3739	19.2446	19.3679	819980.0
2014-01-10 08:00:00	AAPL	Stock	19.3625	19.3625	19.2629	19.2857	998676.0
2014-01-10 08:30:00	AAPL	Stock	19.2857	19.3021	19.1796	19.2746	2157092.0
2014-01-10 09:00:00	AAPL	Stock	19.2821	19.2982	19.2461	19.2729	1083180.0
2014-01-10 09:30:00	AAPL	Stock	19.2796	19.3143	19.0679	19.1075	54775840.0
2014-01-10 10:00:00	AAPL	Stock	19.1075	19.1107	18.9857	19.0479	35613928.0
2014-01-10 10:30:00	AAPL	Stock	19.0486	19.1004	19.0	19.0815	17493028.0
2014-01-10 11:00:00	AAPL	Stock	19.08	19.0882	19.0164	19.0296	12614532.0
2014-01-10 11:30:00	AAPL	Stock	19.0264	19.0264	18.9761	19.0071	15670928.0
2014-01-10 12:00:00	AAPL	Stock	19.0089	19.0289	18.9943	18.9991	7842660.0
2014-01-10 12:30:00	AAPL	Stock	18.9961	19.0168	18.9754	18.9764	7728056.0
2014-01-10 13:00:00	AAPL	Stock	18.9764	19.0043	18.9682	18.9925	6998488.0
2014-01-10 13:30:00	AAPL	Stock	18.9936	19.0157	18.9821	18.9921	7233604.0
2014-01-10 14:00:00	AAPL	Stock	18.9918	19.0036	18.9864	18.9933	6165768.0
2014-01-10 14:30:00	AAPL	Stock	18.9934	19.0336	18.9914	19.025	13281464.0
2014-01-10 15:00:00	AAPL	Stock	19.0246	19.0614	19.0143	19.0229	18110176.0
2014-01-10 15:30:00	AAPL	Stock	19.0225	19.04	19.0174	19.0329	24636500.0
2014-01-10 16:00:00	AAPL	Stock	19.0329	19.1596	19.0179	19.0179	14762300.0
2014-01-10 16:30:00	AAPL	Stock	19.0214	19.0433	19.0179	19.0196	826644.0
2014-01-10 17:00:00	AAPL	Stock	19.0179	19.0336	19.0179	19.025	66416.0
2014-01-10 17:30:00	AAPL	Stock	19.0232	19.0336	19.0232	19.0336	81508.0
2014-01-10 18:00:00	AAPL	Stock	19.0314	19.0321	19.0271	19.0275	26040.0
2014-01-10 18:30:00	AAPL	Stock	19.0329	19.0429	19.0329	19.0404	70728.0
2014-01-10 19:00:00	AAPL	Stock	19.0404	19.0432	19.0339	19.0393	26096.0
2014-01-10 19:30:00	AAPL	Stock	19.0361	19.0425	19.0357	19.0414	22344.0
2014-01-10 04:30:00	MSFT	Stock	35.81	35.9	35.81	35.9	1838.0
2014-01-10 05:00:00	MSFT	Stock	35.9	35.9	35.9	35.9	200.0
2014-01-10 06:00:00	MSFT	Stock	35.85	35.94	35.85	35.94	5400.0
2014-01-10 06:30:00	MSFT	Stock	35.94	36.02	35.94	35.94	3811.0
2014-01-10 07:00:00	MSFT	Stock	35.94	35.99	35.83	35.84	17585.0
2014-01-10 07:30:00	MSFT	Stock	35.84	35.95	35.84	35.86	14319.0
2014-01-10 08:00:00	MSFT	Stock	35.85	35.93	35.83	35.88	190946.0
2014-01-10 08:30:00	MSFT	Stock	35.88	35.92	35.75	35.9	588001.0
2014-01-10 09:00:00	MSFT	Stock	35.92	35.98	35.82	35.93	289138.0
2014-01-10 09:30:00	MSFT	Stock	35.9	36.05	35.83	35.95	6640223.0
2014-01-10 10:00:00	MSFT	Stock	35.95	36.06	35.88	36.04	5021255.0
2014-01-10 10:30:00	MSFT	Stock	36.03	36.11	35.93	36.093	3690176.0
2014-01-10 11:00:00	MSFT	Stock	36.1	36.15	35.94	35.966	3034485.0
2014-01-10 11:30:00	MSFT	Stock	35.96	36.02	35.9	35.93	2893875.0
2014-01-10 12:00:00	MSFT	Stock	35.935	36.1	35.885	35.92	1593915.0
2014-01-10 12:30:00	MSFT	Stock	35.92	35.98	35.83	35.83	1432088.0
2014-01-10 13:00:00	MSFT	Stock	35.83	35.87	35.75	35.865	1617891.0
2014-01-10 13:30:00	MSFT	Stock	35.86	35.966	35.85	35.855	1517823.0
2014-01-10 14:00:00	MSFT	Stock	35.855	35.93	35.83	35.87	996000.0

> showing 50 of 81,479 rows — these rows as CSV

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