PREVIEW / stock_30min / 2018-01-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-26.parquet
  size:    1.7 MB
  rows:    85,059
  symbols: 2,903

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-01-26 04:00:00	AAPL	Stock	43.0025	43.0625	42.9975	43.0	80212.0
2018-01-26 04:30:00	AAPL	Stock	43.0	43.0875	42.9875	43.0875	9600.0
2018-01-26 05:00:00	AAPL	Stock	43.075	43.075	43.075	43.075	2000.0
2018-01-26 05:30:00	AAPL	Stock	43.0875	43.125	43.075	43.125	16544.0
2018-01-26 06:00:00	AAPL	Stock	43.1175	43.17	43.1075	43.125	81152.0
2018-01-26 06:30:00	AAPL	Stock	43.125	43.175	43.1025	43.165	18240.0
2018-01-26 07:00:00	AAPL	Stock	43.1325	43.1375	43.0625	43.075	71188.0
2018-01-26 07:30:00	AAPL	Stock	43.075	43.1175	43.075	43.1175	106640.0
2018-01-26 08:00:00	AAPL	Stock	43.125	43.1825	43.0375	43.0625	237788.0
2018-01-26 08:30:00	AAPL	Stock	43.0625	43.08	43.005	43.05	296692.0
2018-01-26 09:00:00	AAPL	Stock	43.0625	43.0775	42.975	42.9825	231176.0
2018-01-26 09:30:00	AAPL	Stock	43.0	43.0	42.6925	42.88	19992380.0
2018-01-26 10:00:00	AAPL	Stock	42.8775	42.8925	42.5825	42.67	13238968.0
2018-01-26 10:30:00	AAPL	Stock	42.6695	42.8725	42.575	42.825	10136032.0
2018-01-26 11:00:00	AAPL	Stock	42.8275	42.835	42.74	42.7938	6878144.0
2018-01-26 11:30:00	AAPL	Stock	42.795	42.814	42.6775	42.7725	6396252.0
2018-01-26 12:00:00	AAPL	Stock	42.775	42.775	42.6675	42.68	4697172.0
2018-01-26 12:30:00	AAPL	Stock	42.6825	42.6975	42.555	42.5625	7110508.0
2018-01-26 13:00:00	AAPL	Stock	42.5625	42.72	42.515	42.6975	6831004.0
2018-01-26 13:30:00	AAPL	Stock	42.6987	42.785	42.655	42.77	6003692.0
2018-01-26 14:00:00	AAPL	Stock	42.7725	42.8875	42.7	42.72	7922220.0
2018-01-26 14:30:00	AAPL	Stock	42.7225	42.8	42.7075	42.7625	5618472.0
2018-01-26 15:00:00	AAPL	Stock	42.765	42.84	42.7475	42.7675	8454304.0
2018-01-26 15:30:00	AAPL	Stock	42.765	42.875	42.7125	42.8625	18762868.0
2018-01-26 16:00:00	AAPL	Stock	42.8775	42.8775	42.75	42.865	14470156.0
2018-01-26 16:30:00	AAPL	Stock	42.8775	42.8775	42.8125	42.85	5194056.0
2018-01-26 17:00:00	AAPL	Stock	42.85	42.8725	42.85	42.85	46252.0
2018-01-26 17:30:00	AAPL	Stock	42.87	42.8775	42.83	42.85	65588.0
2018-01-26 18:00:00	AAPL	Stock	42.8625	42.875	42.85	42.85	59244.0
2018-01-26 18:30:00	AAPL	Stock	42.85	42.865	42.8375	42.8375	13824.0
2018-01-26 19:00:00	AAPL	Stock	42.8375	42.865	42.8375	42.86	22440.0
2018-01-26 19:30:00	AAPL	Stock	42.8625	42.865	42.825	42.8475	54656.0
2018-01-26 06:00:00	MSFT	Stock	92.99	93.0	92.99	92.99	617.0
2018-01-26 06:30:00	MSFT	Stock	92.99	92.99	92.99	92.99	1559.0
2018-01-26 07:00:00	MSFT	Stock	92.98	92.98	92.85	92.92	3865.0
2018-01-26 07:30:00	MSFT	Stock	92.87	92.92	92.87	92.87	1000.0
2018-01-26 08:00:00	MSFT	Stock	92.9	93.05	92.52	93.02	20606.0
2018-01-26 08:30:00	MSFT	Stock	92.95	92.99	92.86	92.99	3539.0
2018-01-26 09:00:00	MSFT	Stock	92.96	93.09	92.95	93.03	4418.0
2018-01-26 09:30:00	MSFT	Stock	93.12	93.12	92.58	92.93	2401931.0
2018-01-26 10:00:00	MSFT	Stock	92.94	93.01	92.72	92.785	1375352.0
2018-01-26 10:30:00	MSFT	Stock	92.79	93.1	92.79	93.07	1073334.0
2018-01-26 11:00:00	MSFT	Stock	93.075	93.3	93.01	93.25	933541.0
2018-01-26 11:30:00	MSFT	Stock	93.26	93.28	93.12	93.21	892499.0
2018-01-26 12:00:00	MSFT	Stock	93.22	93.36	93.21	93.32	773713.0
2018-01-26 12:30:00	MSFT	Stock	93.325	93.46	93.25	93.25	812796.0
2018-01-26 13:00:00	MSFT	Stock	93.255	93.48	93.25	93.38	631306.0
2018-01-26 13:30:00	MSFT	Stock	93.4	93.6	93.385	93.495	926520.0
2018-01-26 14:00:00	MSFT	Stock	93.495	93.57	93.38	93.41	910841.0
2018-01-26 14:30:00	MSFT	Stock	93.41	93.56	93.36	93.385	1133044.0

> showing 50 of 85,059 rows — these rows as CSV

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