PREVIEW / stock_30min / 2016-10-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-20.parquet
  size:    1.5 MB
  rows:    78,963
  symbols: 3,170

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-10-20 05:00:00	AAPL	Stock	29.305	29.305	29.305	29.305	800.0
2016-10-20 06:00:00	AAPL	Stock	29.25	29.295	29.25	29.295	5676.0
2016-10-20 06:30:00	AAPL	Stock	29.295	29.305	29.295	29.295	3560.0
2016-10-20 07:00:00	AAPL	Stock	29.275	29.2975	29.275	29.2975	1376.0
2016-10-20 07:30:00	AAPL	Stock	29.2975	29.335	29.15	29.1875	39092.0
2016-10-20 08:00:00	AAPL	Stock	29.2975	29.31	29.14	29.2	121312.0
2016-10-20 08:30:00	AAPL	Stock	29.225	29.2925	29.1825	29.275	68488.0
2016-10-20 09:00:00	AAPL	Stock	29.28	29.2925	29.215	29.215	117136.0
2016-10-20 09:30:00	AAPL	Stock	29.215	29.27	29.1425	29.25	11240436.0
2016-10-20 10:00:00	AAPL	Stock	29.2475	29.3275	29.1625	29.215	8862704.0
2016-10-20 10:30:00	AAPL	Stock	29.215	29.215	29.0825	29.1625	11384820.0
2016-10-20 11:00:00	AAPL	Stock	29.165	29.255	29.16	29.245	6153572.0
2016-10-20 11:30:00	AAPL	Stock	29.245	29.255	29.1675	29.2425	4508464.0
2016-10-20 12:00:00	AAPL	Stock	29.245	29.3	29.2375	29.2725	5854656.0
2016-10-20 12:30:00	AAPL	Stock	29.2712	29.34	29.26	29.2912	4689068.0
2016-10-20 13:00:00	AAPL	Stock	29.2925	29.3325	29.28	29.3275	3647284.0
2016-10-20 13:30:00	AAPL	Stock	29.33	29.345	29.2025	29.2225	6602920.0
2016-10-20 14:00:00	AAPL	Stock	29.2225	29.27	29.21	29.25	4444660.0
2016-10-20 14:30:00	AAPL	Stock	29.25	29.3075	29.235	29.2975	4113296.0
2016-10-20 15:00:00	AAPL	Stock	29.2975	29.3025	29.2425	29.2475	3663224.0
2016-10-20 15:30:00	AAPL	Stock	29.2475	29.3125	29.22	29.2525	9224376.0
2016-10-20 16:00:00	AAPL	Stock	29.2525	29.315	29.2525	29.305	5192488.0
2016-10-20 16:30:00	AAPL	Stock	29.265	29.29	29.2625	29.265	136516.0
2016-10-20 17:00:00	AAPL	Stock	29.275	29.2875	29.265	29.2725	19588.0
2016-10-20 17:30:00	AAPL	Stock	29.28	29.285	29.275	29.275	31832.0
2016-10-20 18:00:00	AAPL	Stock	29.275	29.28	29.27	29.2725	29156.0
2016-10-20 18:30:00	AAPL	Stock	29.27	29.275	29.27	29.27	3004.0
2016-10-20 19:00:00	AAPL	Stock	29.2925	29.3025	29.2875	29.3025	6056.0
2016-10-20 19:30:00	AAPL	Stock	29.295	29.305	29.28	29.305	25196.0
2016-10-20 04:00:00	MSFT	Stock	57.8	57.82	57.8	57.82	600.0
2016-10-20 06:00:00	MSFT	Stock	57.74	57.74	57.74	57.74	100.0
2016-10-20 07:00:00	MSFT	Stock	57.73	57.74	57.66	57.73	2916.0
2016-10-20 07:30:00	MSFT	Stock	57.73	57.79	57.68	57.73	2392.0
2016-10-20 08:00:00	MSFT	Stock	57.74	57.74	57.61	57.64	10265.0
2016-10-20 08:30:00	MSFT	Stock	57.64	57.7	57.56	57.6	9550.0
2016-10-20 09:00:00	MSFT	Stock	57.6	57.6	57.51	57.51	6466.0
2016-10-20 09:30:00	MSFT	Stock	57.5	57.52	56.78	57.17	4807571.0
2016-10-20 10:00:00	MSFT	Stock	57.165	57.31	56.87	56.88	3169477.0
2016-10-20 10:30:00	MSFT	Stock	56.885	56.89	56.66	56.779	3407533.0
2016-10-20 11:00:00	MSFT	Stock	56.77	57.01	56.76	56.996	2267731.0
2016-10-20 11:30:00	MSFT	Stock	56.99	57.08	56.98	57.07	1710126.0
2016-10-20 12:00:00	MSFT	Stock	57.07	57.275	57.055	57.15	1736010.0
2016-10-20 12:30:00	MSFT	Stock	57.15	57.24	57.14	57.19	1690452.0
2016-10-20 13:00:00	MSFT	Stock	57.18	57.21	57.09	57.145	1406088.0
2016-10-20 13:30:00	MSFT	Stock	57.145	57.16	56.9	57.01	2879584.0
2016-10-20 14:00:00	MSFT	Stock	57.02	57.06	56.97	56.99	1742827.0
2016-10-20 14:30:00	MSFT	Stock	57.0	57.16	56.98	57.15	2555562.0
2016-10-20 15:00:00	MSFT	Stock	57.155	57.22	57.07	57.14	2498326.0
2016-10-20 15:30:00	MSFT	Stock	57.135	57.37	57.09	57.24	7922175.0
2016-10-20 16:00:00	MSFT	Stock	57.25	60.53	57.07	60.52	6588310.0

> showing 50 of 78,963 rows — these rows as CSV

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