PREVIEW / stock_30min / 2015-08-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-27.parquet
  size:    1.6 MB
  rows:    85,723
  symbols: 3,485

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
2015-08-27 04:00:00	AAPL	Stock	27.5825	28.0975	27.5825	28.0725	114416.0
2015-08-27 04:30:00	AAPL	Stock	28.0725	28.12	28.0	28.08	50968.0
2015-08-27 05:00:00	AAPL	Stock	28.08	28.1125	28.0625	28.1	57912.0
2015-08-27 05:30:00	AAPL	Stock	28.075	28.1	28.025	28.0725	40012.0
2015-08-27 06:00:00	AAPL	Stock	28.095	28.1	28.0375	28.05	78832.0
2015-08-27 06:30:00	AAPL	Stock	28.05	28.125	28.005	28.005	724264.0
2015-08-27 07:00:00	AAPL	Stock	28.01	28.075	27.9875	28.0025	305748.0
2015-08-27 07:30:00	AAPL	Stock	28.015	28.0375	27.9075	27.9075	387344.0
2015-08-27 08:00:00	AAPL	Stock	27.905	28.1	27.7825	27.9225	1714076.0
2015-08-27 08:30:00	AAPL	Stock	27.9225	28.0	27.875	27.98	1365052.0
2015-08-27 09:00:00	AAPL	Stock	27.98	28.0725	27.945	28.0575	1711452.0
2015-08-27 09:30:00	AAPL	Stock	28.0575	28.075	27.6825	27.7625	47477248.0
2015-08-27 10:00:00	AAPL	Stock	27.7625	27.8675	27.6	27.7925	25847532.0
2015-08-27 10:30:00	AAPL	Stock	27.8025	28.0	27.7575	27.998	18167312.0
2015-08-27 11:00:00	AAPL	Stock	27.995	28.1975	27.9525	28.0438	21014900.0
2015-08-27 11:30:00	AAPL	Stock	28.0475	28.1	27.875	28.025	16100304.0
2015-08-27 12:00:00	AAPL	Stock	28.0275	28.25	28.0225	28.25	16032380.0
2015-08-27 12:30:00	AAPL	Stock	28.2475	28.31	28.1775	28.2575	15700652.0
2015-08-27 13:00:00	AAPL	Stock	28.2625	28.3	28.18	28.2	14762748.0
2015-08-27 13:30:00	AAPL	Stock	28.2	28.26	28.0975	28.2125	13897736.0
2015-08-27 14:00:00	AAPL	Stock	28.21	28.2442	27.855	27.9175	19305308.0
2015-08-27 14:30:00	AAPL	Stock	27.916	28.0375	27.65	27.68	21637016.0
2015-08-27 15:00:00	AAPL	Stock	27.685	27.8975	27.505	27.865	28805732.0
2015-08-27 15:30:00	AAPL	Stock	27.865	28.23	27.7925	28.23	33386032.0
2015-08-27 16:00:00	AAPL	Stock	28.23	28.24	27.8085	28.1875	15022152.0
2015-08-27 16:30:00	AAPL	Stock	28.1875	28.23	28.145	28.22	346204.0
2015-08-27 17:00:00	AAPL	Stock	28.22	28.2375	28.2025	28.2325	193540.0
2015-08-27 17:30:00	AAPL	Stock	28.2375	28.2475	28.225	28.245	156120.0
2015-08-27 18:00:00	AAPL	Stock	28.245	28.2475	28.2275	28.2325	99256.0
2015-08-27 18:30:00	AAPL	Stock	28.2375	28.2475	28.235	28.24	52400.0
2015-08-27 19:00:00	AAPL	Stock	28.24	28.2475	28.2275	28.23	75884.0
2015-08-27 19:30:00	AAPL	Stock	28.2375	28.2475	28.2375	28.245	124572.0
2015-08-27 04:00:00	MSFT	Stock	43.17	43.17	43.08	43.17	7415.0
2015-08-27 05:00:00	MSFT	Stock	43.28	43.28	43.28	43.28	200.0
2015-08-27 05:30:00	MSFT	Stock	43.27	43.27	43.27	43.27	200.0
2015-08-27 06:00:00	MSFT	Stock	43.25	43.25	43.24	43.24	650.0
2015-08-27 06:30:00	MSFT	Stock	43.28	43.28	43.22	43.22	900.0
2015-08-27 07:00:00	MSFT	Stock	43.21	43.21	43.1	43.1	1200.0
2015-08-27 07:30:00	MSFT	Stock	43.13	43.13	42.93	42.93	10146.0
2015-08-27 08:00:00	MSFT	Stock	43.0	43.1	42.93	43.05	9872.0
2015-08-27 08:30:00	MSFT	Stock	43.05	43.15	43.05	43.15	36682.0
2015-08-27 09:00:00	MSFT	Stock	43.16	43.24	43.11	43.18	19751.0
2015-08-27 09:30:00	MSFT	Stock	43.23	43.64	43.12	43.49	6812073.0
2015-08-27 10:00:00	MSFT	Stock	43.49	43.69	43.25	43.505	4331991.0
2015-08-27 10:30:00	MSFT	Stock	43.51	43.805	43.374	43.74	3054521.0
2015-08-27 11:00:00	MSFT	Stock	43.74	43.79	43.61	43.67	1994758.0
2015-08-27 11:30:00	MSFT	Stock	43.67	43.83	43.61	43.79	1686150.0
2015-08-27 12:00:00	MSFT	Stock	43.79	43.95	43.68	43.69	2306115.0
2015-08-27 12:30:00	MSFT	Stock	43.69	43.81	43.56	43.78	1653293.0
2015-08-27 13:00:00	MSFT	Stock	43.77	43.95	43.67	43.86	2417510.0

> showing 50 of 85,723 rows — these rows as CSV

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