PREVIEW / stock_30min / 2016-01-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-19.parquet
  size:    1.6 MB
  rows:    86,168
  symbols: 3,404

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
2016-01-19 04:00:00	AAPL	Stock	24.47	24.7475	24.47	24.6925	12540.0
2016-01-19 04:30:00	AAPL	Stock	24.6925	24.74	24.6725	24.71	15912.0
2016-01-19 05:00:00	AAPL	Stock	24.75	24.75	24.6875	24.6875	5944.0
2016-01-19 05:30:00	AAPL	Stock	24.745	24.7775	24.71	24.775	29852.0
2016-01-19 06:00:00	AAPL	Stock	24.78	24.795	24.7625	24.775	32352.0
2016-01-19 06:30:00	AAPL	Stock	24.7775	24.8125	24.7575	24.7575	95608.0
2016-01-19 07:00:00	AAPL	Stock	24.715	24.7375	24.6425	24.655	133836.0
2016-01-19 07:30:00	AAPL	Stock	24.655	24.6575	24.57	24.575	175560.0
2016-01-19 08:00:00	AAPL	Stock	24.575	24.78	24.5525	24.675	386796.0
2016-01-19 08:30:00	AAPL	Stock	24.68	24.7125	24.6625	24.6975	239188.0
2016-01-19 09:00:00	AAPL	Stock	24.675	24.695	24.5825	24.6275	762056.0
2016-01-19 09:30:00	AAPL	Stock	24.6025	24.6625	24.4125	24.47	24925120.0
2016-01-19 10:00:00	AAPL	Stock	24.47	24.525	24.38	24.5125	14868120.0
2016-01-19 10:30:00	AAPL	Stock	24.515	24.52	24.2225	24.2512	14368980.0
2016-01-19 11:00:00	AAPL	Stock	24.2505	24.295	24.0575	24.1875	14328208.0
2016-01-19 11:30:00	AAPL	Stock	24.1875	24.2275	24.0992	24.1175	10908452.0
2016-01-19 12:00:00	AAPL	Stock	24.1162	24.185	24.0425	24.1325	9872476.0
2016-01-19 12:30:00	AAPL	Stock	24.135	24.2125	24.0725	24.1475	8692696.0
2016-01-19 13:00:00	AAPL	Stock	24.1475	24.2175	24.1125	24.1412	8518508.0
2016-01-19 13:30:00	AAPL	Stock	24.14	24.155	24.0475	24.0675	7597036.0
2016-01-19 14:00:00	AAPL	Stock	24.0675	24.0825	23.875	24.02	15034884.0
2016-01-19 14:30:00	AAPL	Stock	24.02	24.0575	23.8875	23.9775	10802632.0
2016-01-19 15:00:00	AAPL	Stock	23.975	24.1825	23.9475	24.1725	12471264.0
2016-01-19 15:30:00	AAPL	Stock	24.1725	24.25	24.15	24.17	21177444.0
2016-01-19 16:00:00	AAPL	Stock	24.165	24.2242	24.1275	24.175	9072756.0
2016-01-19 16:30:00	AAPL	Stock	24.1525	24.2	24.1325	24.15	108104.0
2016-01-19 17:00:00	AAPL	Stock	24.15	24.15	24.11	24.1225	41736.0
2016-01-19 17:30:00	AAPL	Stock	24.1125	24.165	24.085	24.085	309540.0
2016-01-19 18:00:00	AAPL	Stock	24.0975	24.16	24.0975	24.1475	34900.0
2016-01-19 18:30:00	AAPL	Stock	24.14	24.1875	24.1375	24.15	54836.0
2016-01-19 19:00:00	AAPL	Stock	24.15	24.15	24.0775	24.1	25000.0
2016-01-19 19:30:00	AAPL	Stock	24.1125	24.15	24.1125	24.125	37212.0
2016-01-19 04:00:00	MSFT	Stock	51.6	51.6	51.6	51.6	2000.0
2016-01-19 04:30:00	MSFT	Stock	51.6	51.6	51.6	51.6	100.0
2016-01-19 05:00:00	MSFT	Stock	51.62	51.77	51.62	51.77	1029.0
2016-01-19 05:30:00	MSFT	Stock	51.9	51.9	51.88	51.88	1431.0
2016-01-19 06:00:00	MSFT	Stock	51.9	51.9	51.9	51.9	100.0
2016-01-19 06:30:00	MSFT	Stock	51.83	51.9	51.83	51.9	6500.0
2016-01-19 07:00:00	MSFT	Stock	51.85	51.96	51.73	51.73	11113.0
2016-01-19 07:30:00	MSFT	Stock	51.73	51.85	51.7	51.79	9620.0
2016-01-19 08:00:00	MSFT	Stock	51.84	51.85	51.66	51.68	26396.0
2016-01-19 08:30:00	MSFT	Stock	51.74	51.9	50.99	51.76	110137.0
2016-01-19 09:00:00	MSFT	Stock	51.76	51.76	51.49	51.49	45922.0
2016-01-19 09:30:00	MSFT	Stock	51.53	51.68	51.005	51.17	5409546.0
2016-01-19 10:00:00	MSFT	Stock	51.18	51.33	51.0	51.17	2884824.0
2016-01-19 10:30:00	MSFT	Stock	51.161	51.25	50.67	50.71	2955957.0
2016-01-19 11:00:00	MSFT	Stock	50.705	50.9	50.555	50.68	2791173.0
2016-01-19 11:30:00	MSFT	Stock	50.675	50.93	50.585	50.88	2588871.0
2016-01-19 12:00:00	MSFT	Stock	50.87	50.91	50.58	50.65	2038229.0
2016-01-19 12:30:00	MSFT	Stock	50.64	50.76	50.43	50.534	1997832.0

> showing 50 of 86,168 rows — these rows as CSV

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