PREVIEW / stock_30min / 2018-02-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-28.parquet
  size:    1.7 MB
  rows:    83,275
  symbols: 2,880

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
2018-02-28 04:00:00	AAPL	Stock	44.6775	44.745	44.6625	44.71	46440.0
2018-02-28 04:30:00	AAPL	Stock	44.71	44.7375	44.71	44.7375	1600.0
2018-02-28 05:00:00	AAPL	Stock	44.735	44.735	44.705	44.705	3824.0
2018-02-28 05:30:00	AAPL	Stock	44.6625	44.72	44.6375	44.6375	2960.0
2018-02-28 06:00:00	AAPL	Stock	44.6275	44.695	44.5925	44.695	2328.0
2018-02-28 06:30:00	AAPL	Stock	44.635	44.635	44.625	44.625	2080.0
2018-02-28 07:00:00	AAPL	Stock	44.645	44.73	44.6425	44.6425	74172.0
2018-02-28 07:30:00	AAPL	Stock	44.6375	44.7	44.6375	44.7	42320.0
2018-02-28 08:00:00	AAPL	Stock	44.7125	44.7875	44.635	44.7675	218508.0
2018-02-28 08:30:00	AAPL	Stock	44.7675	44.8725	44.7675	44.8	242828.0
2018-02-28 09:00:00	AAPL	Stock	44.81	44.875	44.78	44.8125	310920.0
2018-02-28 09:30:00	AAPL	Stock	44.8325	44.9822	44.77	44.965	13756472.0
2018-02-28 10:00:00	AAPL	Stock	44.965	45.1225	44.965	45.08	10977584.0
2018-02-28 10:30:00	AAPL	Stock	45.075	45.1538	44.8	44.9065	11457388.0
2018-02-28 11:00:00	AAPL	Stock	44.9075	44.9475	44.775	44.8438	7664244.0
2018-02-28 11:30:00	AAPL	Stock	44.8425	44.935	44.6275	44.785	7520244.0
2018-02-28 12:00:00	AAPL	Stock	44.785	44.8525	44.76	44.7725	3649116.0
2018-02-28 12:30:00	AAPL	Stock	44.7725	44.9975	44.7225	44.97	4547812.0
2018-02-28 13:00:00	AAPL	Stock	44.9675	45.0025	44.91	44.9875	4401804.0
2018-02-28 13:30:00	AAPL	Stock	44.985	45.0875	44.855	45.075	6137192.0
2018-02-28 14:00:00	AAPL	Stock	45.0775	45.1225	45.0575	45.072	5151888.0
2018-02-28 14:30:00	AAPL	Stock	45.0675	45.07	44.82	44.865	5360240.0
2018-02-28 15:00:00	AAPL	Stock	44.8675	44.905	44.745	44.84	7957012.0
2018-02-28 15:30:00	AAPL	Stock	44.845	44.86	44.5125	44.5325	16721276.0
2018-02-28 16:00:00	AAPL	Stock	44.5325	44.8112	44.53	44.61	21438764.0
2018-02-28 16:30:00	AAPL	Stock	44.61	44.61	44.5775	44.61	31032.0
2018-02-28 17:00:00	AAPL	Stock	44.605	44.61	44.575	44.5875	30376.0
2018-02-28 17:30:00	AAPL	Stock	44.595	44.605	44.575	44.605	15204.0
2018-02-28 18:00:00	AAPL	Stock	44.595	44.6125	44.575	44.575	50488.0
2018-02-28 18:30:00	AAPL	Stock	44.575	44.6175	44.575	44.6175	37280.0
2018-02-28 19:00:00	AAPL	Stock	44.6175	44.6175	44.6	44.6025	12916.0
2018-02-28 19:30:00	AAPL	Stock	44.605	44.625	44.59	44.6225	34440.0
2018-02-28 04:00:00	MSFT	Stock	94.62	94.62	94.62	94.62	200.0
2018-02-28 05:30:00	MSFT	Stock	94.52	94.52	94.51	94.51	3100.0
2018-02-28 06:30:00	MSFT	Stock	94.51	94.51	94.33	94.33	611.0
2018-02-28 07:00:00	MSFT	Stock	94.52	94.52	94.45	94.49	2100.0
2018-02-28 07:30:00	MSFT	Stock	94.56	94.56	94.49	94.55	1619.0
2018-02-28 08:00:00	MSFT	Stock	94.34	94.72	94.34	94.51	3245.0
2018-02-28 08:30:00	MSFT	Stock	94.73	94.79	94.7	94.7	6279.0
2018-02-28 09:00:00	MSFT	Stock	94.74	94.84	94.74	94.8	6173.0
2018-02-28 09:30:00	MSFT	Stock	94.8	95.36	94.695	95.275	2372392.0
2018-02-28 10:00:00	MSFT	Stock	95.28	95.31	95.02	95.16	1085990.0
2018-02-28 10:30:00	MSFT	Stock	95.17	95.3	94.53	94.69	1344454.0
2018-02-28 11:00:00	MSFT	Stock	94.7	95.11	94.62	95.025	1286441.0
2018-02-28 11:30:00	MSFT	Stock	95.025	95.08	94.56	94.89	1103920.0
2018-02-28 12:00:00	MSFT	Stock	94.9	95.015	94.732	94.84	830230.0
2018-02-28 12:30:00	MSFT	Stock	94.83	95.479	94.74	95.415	928997.0
2018-02-28 13:00:00	MSFT	Stock	95.42	95.54	95.28	95.52	978477.0
2018-02-28 13:30:00	MSFT	Stock	95.52	95.61	95.33	95.596	1029400.0
2018-02-28 14:00:00	MSFT	Stock	95.595	95.705	95.44	95.5	1095635.0

> showing 50 of 83,275 rows — these rows as CSV

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