PREVIEW / stock_30min / 2017-05-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-24.parquet
  size:    1.6 MB
  rows:    80,344
  symbols: 3,023

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-05-24 04:30:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	400.0
2017-05-24 06:00:00	AAPL	Stock	38.535	38.55	38.535	38.55	5400.0
2017-05-24 06:30:00	AAPL	Stock	38.5425	38.545	38.5	38.5	10588.0
2017-05-24 07:00:00	AAPL	Stock	38.4775	38.4775	38.475	38.475	2772.0
2017-05-24 07:30:00	AAPL	Stock	38.4975	38.5	38.475	38.5	8596.0
2017-05-24 08:00:00	AAPL	Stock	38.5	38.535	38.4275	38.4725	69040.0
2017-05-24 08:30:00	AAPL	Stock	38.4675	38.505	38.4625	38.475	61332.0
2017-05-24 09:00:00	AAPL	Stock	38.4625	38.475	38.4125	38.4625	159504.0
2017-05-24 09:30:00	AAPL	Stock	38.46	38.5425	38.4025	38.41	8477048.0
2017-05-24 10:00:00	AAPL	Stock	38.4112	38.4285	38.26	38.335	8062780.0
2017-05-24 10:30:00	AAPL	Stock	38.335	38.3975	38.285	38.2875	4286812.0
2017-05-24 11:00:00	AAPL	Stock	38.2875	38.315	38.2375	38.2625	4564876.0
2017-05-24 11:30:00	AAPL	Stock	38.2625	38.2898	38.1675	38.2225	6149400.0
2017-05-24 12:00:00	AAPL	Stock	38.22	38.295	38.2125	38.29	3608064.0
2017-05-24 12:30:00	AAPL	Stock	38.2912	38.33	38.27	38.2712	2873556.0
2017-05-24 13:00:00	AAPL	Stock	38.271	38.3025	38.2475	38.275	2244240.0
2017-05-24 13:30:00	AAPL	Stock	38.275	38.335	38.275	38.2962	2046064.0
2017-05-24 14:00:00	AAPL	Stock	38.2975	38.3725	38.2725	38.3105	8109064.0
2017-05-24 14:30:00	AAPL	Stock	38.31	38.315	38.2675	38.28	2335408.0
2017-05-24 15:00:00	AAPL	Stock	38.2825	38.305	38.2275	38.3038	3633872.0
2017-05-24 15:30:00	AAPL	Stock	38.3043	38.3375	38.275	38.325	8799908.0
2017-05-24 16:00:00	AAPL	Stock	38.3075	38.335	38.3	38.335	4483300.0
2017-05-24 16:30:00	AAPL	Stock	38.325	38.335	38.325	38.335	51732.0
2017-05-24 17:00:00	AAPL	Stock	38.325	38.34	38.325	38.325	54584.0
2017-05-24 17:30:00	AAPL	Stock	38.325	38.3375	38.325	38.325	4528.0
2017-05-24 18:00:00	AAPL	Stock	38.325	38.3375	38.325	38.33	2300.0
2017-05-24 18:30:00	AAPL	Stock	38.325	38.34	38.3025	38.3175	18240.0
2017-05-24 19:00:00	AAPL	Stock	38.3175	38.34	38.315	38.34	13400.0
2017-05-24 19:30:00	AAPL	Stock	38.3225	38.34	38.3125	38.3125	7460.0
2017-05-24 08:00:00	MSFT	Stock	68.53	68.7	68.53	68.7	2212.0
2017-05-24 08:30:00	MSFT	Stock	68.7	68.74	68.7	68.7	1449.0
2017-05-24 09:00:00	MSFT	Stock	68.74	68.88	68.7	68.87	5125.0
2017-05-24 09:30:00	MSFT	Stock	68.87	68.88	68.468	68.59	1773187.0
2017-05-24 10:00:00	MSFT	Stock	68.6	68.64	68.505	68.585	786858.0
2017-05-24 10:30:00	MSFT	Stock	68.59	68.65	68.56	68.59	547569.0
2017-05-24 11:00:00	MSFT	Stock	68.58	68.6	68.52	68.555	634357.0
2017-05-24 11:30:00	MSFT	Stock	68.55	68.67	68.55	68.6	652437.0
2017-05-24 12:00:00	MSFT	Stock	68.607	68.655	68.57	68.6	454386.0
2017-05-24 12:30:00	MSFT	Stock	68.6	68.61	68.55	68.58	340546.0
2017-05-24 13:00:00	MSFT	Stock	68.59	68.61	68.45	68.485	467901.0
2017-05-24 13:30:00	MSFT	Stock	68.485	68.57	68.48	68.56	430299.0
2017-05-24 14:00:00	MSFT	Stock	68.56	68.69	68.51	68.64	1093471.0
2017-05-24 14:30:00	MSFT	Stock	68.64	68.685	68.595	68.645	519321.0
2017-05-24 15:00:00	MSFT	Stock	68.65	68.66	68.59	68.62	683098.0
2017-05-24 15:30:00	MSFT	Stock	68.63	68.79	68.625	68.77	3042675.0
2017-05-24 16:00:00	MSFT	Stock	68.77	68.77	68.69	68.75	1911650.0
2017-05-24 16:30:00	MSFT	Stock	68.77	68.77	68.75	68.77	29777.0
2017-05-24 17:00:00	MSFT	Stock	68.77	68.77	68.75	68.75	20377.0
2017-05-24 17:30:00	MSFT	Stock	68.69	68.69	68.69	68.69	278.0
2017-05-24 18:00:00	MSFT	Stock	68.69	68.69	68.69	68.69	205.0

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

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