PREVIEW / stock_30min / 2017-03-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-23.parquet
  size:    1.6 MB
  rows:    80,520
  symbols: 3,061

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
2017-03-23 04:00:00	AAPL	Stock	35.32	35.32	35.32	35.32	1808.0
2017-03-23 04:30:00	AAPL	Stock	35.285	35.3	35.2825	35.3	2460.0
2017-03-23 07:00:00	AAPL	Stock	35.3475	35.3625	35.3475	35.3625	13844.0
2017-03-23 07:30:00	AAPL	Stock	35.365	35.37	35.325	35.34	22912.0
2017-03-23 08:00:00	AAPL	Stock	35.35	35.375	35.325	35.3475	40420.0
2017-03-23 08:30:00	AAPL	Stock	35.3475	35.3875	35.335	35.335	181684.0
2017-03-23 09:00:00	AAPL	Stock	35.33	35.3475	35.3	35.32	192192.0
2017-03-23 09:30:00	AAPL	Stock	35.315	35.37	35.155	35.19	11160432.0
2017-03-23 10:00:00	AAPL	Stock	35.1905	35.2722	35.1525	35.22	5396892.0
2017-03-23 10:30:00	AAPL	Stock	35.22	35.325	35.2088	35.2825	4570684.0
2017-03-23 11:00:00	AAPL	Stock	35.285	35.3475	35.26	35.3175	4576228.0
2017-03-23 11:30:00	AAPL	Stock	35.3175	35.335	35.2925	35.33	2714492.0
2017-03-23 12:00:00	AAPL	Stock	35.33	35.396	35.32	35.365	3440420.0
2017-03-23 12:30:00	AAPL	Stock	35.365	35.3675	35.26	35.295	3376060.0
2017-03-23 13:00:00	AAPL	Stock	35.2975	35.3	35.1725	35.18	5388120.0
2017-03-23 13:30:00	AAPL	Stock	35.18	35.245	35.175	35.21	3809428.0
2017-03-23 14:00:00	AAPL	Stock	35.2075	35.31	35.2	35.2875	3721424.0
2017-03-23 14:30:00	AAPL	Stock	35.29	35.335	35.271	35.2825	4029540.0
2017-03-23 15:00:00	AAPL	Stock	35.2825	35.285	35.22	35.2275	5720956.0
2017-03-23 15:30:00	AAPL	Stock	35.23	35.2425	35.155	35.23	10167140.0
2017-03-23 16:00:00	AAPL	Stock	35.23	35.2325	35.1925	35.22	5831856.0
2017-03-23 16:30:00	AAPL	Stock	35.225	35.23	35.195	35.21	26312.0
2017-03-23 17:00:00	AAPL	Stock	35.21	35.21	35.1875	35.19	13484.0
2017-03-23 17:30:00	AAPL	Stock	35.1875	35.1975	35.1875	35.1975	2400.0
2017-03-23 18:00:00	AAPL	Stock	35.1975	35.2475	35.1975	35.2475	45040.0
2017-03-23 18:30:00	AAPL	Stock	35.2475	35.2475	35.24	35.24	15400.0
2017-03-23 19:00:00	AAPL	Stock	35.24	35.2475	35.24	35.24	15448.0
2017-03-23 19:30:00	AAPL	Stock	35.2475	35.26	35.2325	35.25	16088.0
2017-03-23 04:30:00	MSFT	Stock	65.02	65.02	65.02	65.02	100.0
2017-03-23 06:30:00	MSFT	Stock	65.03	65.05	65.03	65.05	1500.0
2017-03-23 07:00:00	MSFT	Stock	65.1	65.1	65.1	65.1	100.0
2017-03-23 08:00:00	MSFT	Stock	65.1	65.1	65.0	65.0	2508.0
2017-03-23 09:00:00	MSFT	Stock	65.01	65.09	64.92	64.96	10281.0
2017-03-23 09:30:00	MSFT	Stock	64.94	65.235	64.82	65.06	2038645.0
2017-03-23 10:00:00	MSFT	Stock	65.07	65.095	64.77	64.82	1190623.0
2017-03-23 10:30:00	MSFT	Stock	64.83	64.96	64.78	64.91	991038.0
2017-03-23 11:00:00	MSFT	Stock	64.91	65.07	64.85	65.03	1089534.0
2017-03-23 11:30:00	MSFT	Stock	65.03	65.15	65.01	65.12	606977.0
2017-03-23 12:00:00	MSFT	Stock	65.11	65.19	65.09	65.17	605276.0
2017-03-23 12:30:00	MSFT	Stock	65.165	65.195	65.0	65.09	1097566.0
2017-03-23 13:00:00	MSFT	Stock	65.1	65.12	64.861	64.893	1005564.0
2017-03-23 13:30:00	MSFT	Stock	64.89	65.04	64.862	64.97	798046.0
2017-03-23 14:00:00	MSFT	Stock	64.96	65.06	64.95	65.03	594347.0
2017-03-23 14:30:00	MSFT	Stock	65.03	65.1	64.975	65.005	699927.0
2017-03-23 15:00:00	MSFT	Stock	65.01	65.02	64.83	64.83	1176648.0
2017-03-23 15:30:00	MSFT	Stock	64.84	64.96	64.765	64.87	3395846.0
2017-03-23 16:00:00	MSFT	Stock	64.87	64.93	64.87	64.9	2070929.0
2017-03-23 16:30:00	MSFT	Stock	64.9	64.9	64.87	64.87	447400.0
2017-03-23 18:00:00	MSFT	Stock	64.92	64.92	64.92	64.92	2000.0
2017-03-23 18:30:00	MSFT	Stock	64.87	64.87	64.87	64.87	100.0

> showing 50 of 80,520 rows — these rows as CSV

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