PREVIEW / stock_30min / 2018-06-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-20.parquet
  size:    1.7 MB
  rows:    84,224
  symbols: 2,825

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-06-20 04:00:00	AAPL	Stock	46.65	46.65	46.5	46.5	1176.0
2018-06-20 04:30:00	AAPL	Stock	46.62	46.62	46.62	46.62	400.0
2018-06-20 05:00:00	AAPL	Stock	46.62	46.62	46.575	46.575	4756.0
2018-06-20 05:30:00	AAPL	Stock	46.685	46.6875	46.675	46.675	10436.0
2018-06-20 06:00:00	AAPL	Stock	46.625	46.65	46.625	46.65	1280.0
2018-06-20 06:30:00	AAPL	Stock	46.625	46.6275	46.6225	46.625	3200.0
2018-06-20 07:00:00	AAPL	Stock	46.675	46.735	46.6375	46.6725	130452.0
2018-06-20 07:30:00	AAPL	Stock	46.6825	46.7	46.64	46.65	79176.0
2018-06-20 08:00:00	AAPL	Stock	46.665	46.75	46.64	46.675	246792.0
2018-06-20 08:30:00	AAPL	Stock	46.675	46.6975	46.635	46.675	134304.0
2018-06-20 09:00:00	AAPL	Stock	46.685	46.695	46.575	46.59	176304.0
2018-06-20 09:30:00	AAPL	Stock	46.5975	46.7425	46.525	46.686	11490852.0
2018-06-20 10:00:00	AAPL	Stock	46.685	46.7175	46.4912	46.515	5901740.0
2018-06-20 10:30:00	AAPL	Stock	46.5175	46.61	46.4325	46.5928	5073900.0
2018-06-20 11:00:00	AAPL	Stock	46.595	46.6275	46.4875	46.515	3825156.0
2018-06-20 11:30:00	AAPL	Stock	46.515	46.54	46.455	46.5012	2922852.0
2018-06-20 12:00:00	AAPL	Stock	46.5025	46.645	46.488	46.6425	3591512.0
2018-06-20 12:30:00	AAPL	Stock	46.6425	46.74	46.635	46.7112	3800320.0
2018-06-20 13:00:00	AAPL	Stock	46.71	46.735	46.6475	46.6512	2823540.0
2018-06-20 13:30:00	AAPL	Stock	46.6525	46.8	46.65	46.7775	3209512.0
2018-06-20 14:00:00	AAPL	Stock	46.7812	46.7825	46.6575	46.71	3273888.0
2018-06-20 14:30:00	AAPL	Stock	46.7075	46.7075	46.5792	46.6038	3204172.0
2018-06-20 15:00:00	AAPL	Stock	46.605	46.6688	46.575	46.66	3124084.0
2018-06-20 15:30:00	AAPL	Stock	46.662	46.7275	46.5825	46.625	8211296.0
2018-06-20 16:00:00	AAPL	Stock	46.6188	46.645	46.6075	46.6275	12400172.0
2018-06-20 16:30:00	AAPL	Stock	46.6275	46.6425	46.625	46.6375	177548.0
2018-06-20 17:00:00	AAPL	Stock	46.6375	46.65	46.615	46.6475	97304.0
2018-06-20 17:30:00	AAPL	Stock	46.6475	46.8	46.64	46.8	85276.0
2018-06-20 18:00:00	AAPL	Stock	46.8	46.8475	46.755	46.8125	309452.0
2018-06-20 18:30:00	AAPL	Stock	46.815	46.9375	46.815	46.935	76648.0
2018-06-20 19:00:00	AAPL	Stock	46.9375	46.95	46.9	46.9	19724.0
2018-06-20 19:30:00	AAPL	Stock	46.9125	46.925	46.8775	46.8775	28364.0
2018-06-20 04:00:00	MSFT	Stock	101.3	101.3	101.25	101.25	360.0
2018-06-20 04:30:00	MSFT	Stock	101.08	101.08	101.08	101.08	100.0
2018-06-20 05:00:00	MSFT	Stock	101.23	101.25	101.23	101.25	200.0
2018-06-20 05:30:00	MSFT	Stock	101.39	101.39	101.39	101.39	200.0
2018-06-20 06:00:00	MSFT	Stock	101.39	101.39	101.23	101.23	1350.0
2018-06-20 07:00:00	MSFT	Stock	101.2	101.2	100.98	101.0	2941.0
2018-06-20 07:30:00	MSFT	Stock	101.03	101.2	101.01	101.11	5065.0
2018-06-20 08:00:00	MSFT	Stock	101.23	101.24	101.05	101.15	6157.0
2018-06-20 08:30:00	MSFT	Stock	101.18	101.32	101.15	101.24	9639.0
2018-06-20 09:00:00	MSFT	Stock	101.3	101.39	101.15	101.2	19519.0
2018-06-20 09:30:00	MSFT	Stock	101.24	101.84	101.12	101.77	3342473.0
2018-06-20 10:00:00	MSFT	Stock	101.77	101.97	101.46	101.475	2194847.0
2018-06-20 10:30:00	MSFT	Stock	101.48	101.79	101.35	101.733	1464993.0
2018-06-20 11:00:00	MSFT	Stock	101.74	101.81	101.514	101.75	1231049.0
2018-06-20 11:30:00	MSFT	Stock	101.75	101.92	101.52	101.915	1026615.0
2018-06-20 12:00:00	MSFT	Stock	101.92	102.23	101.9	102.08	1372839.0
2018-06-20 12:30:00	MSFT	Stock	102.08	102.41	102.05	102.24	1035963.0
2018-06-20 13:00:00	MSFT	Stock	102.235	102.24	101.975	102.01	732794.0

> showing 50 of 84,224 rows — these rows as CSV

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