PREVIEW / stock_30min / 2018-09-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-28.parquet
  size:    1.7 MB
  rows:    84,299
  symbols: 2,797

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-09-28 04:00:00	AAPL	Stock	56.125	56.125	56.125	56.125	5380.0
2018-09-28 04:30:00	AAPL	Stock	56.1275	56.1275	56.1275	56.1275	564.0
2018-09-28 05:00:00	AAPL	Stock	56.2	56.2	56.2	56.2	800.0
2018-09-28 05:30:00	AAPL	Stock	56.125	56.18	56.115	56.18	2800.0
2018-09-28 06:00:00	AAPL	Stock	56.1975	56.1975	56.0375	56.0375	8504.0
2018-09-28 06:30:00	AAPL	Stock	56.005	56.0625	56.0	56.0	11936.0
2018-09-28 07:00:00	AAPL	Stock	56.0	56.0625	55.94	55.9625	63492.0
2018-09-28 07:30:00	AAPL	Stock	55.9925	56.0375	55.905	55.98	73820.0
2018-09-28 08:00:00	AAPL	Stock	55.9775	56.1725	55.9	56.0825	368404.0
2018-09-28 08:30:00	AAPL	Stock	56.085	56.1875	56.065	56.175	245604.0
2018-09-28 09:00:00	AAPL	Stock	56.1625	56.2025	56.1	56.2025	228540.0
2018-09-28 09:30:00	AAPL	Stock	56.1975	56.3725	56.005	56.185	11232164.0
2018-09-28 10:00:00	AAPL	Stock	56.1825	56.3025	56.14	56.2208	5717456.0
2018-09-28 10:30:00	AAPL	Stock	56.22	56.4575	56.1625	56.3925	5281916.0
2018-09-28 11:00:00	AAPL	Stock	56.395	56.455	56.2325	56.2675	4165668.0
2018-09-28 11:30:00	AAPL	Stock	56.2675	56.305	56.2175	56.2638	3281448.0
2018-09-28 12:00:00	AAPL	Stock	56.2625	56.3092	56.2475	56.2575	2292972.0
2018-09-28 12:30:00	AAPL	Stock	56.259	56.28	56.12	56.2525	4218436.0
2018-09-28 13:00:00	AAPL	Stock	56.2475	56.2725	56.1625	56.2375	2265520.0
2018-09-28 13:30:00	AAPL	Stock	56.2375	56.3025	56.1975	56.2485	2479404.0
2018-09-28 14:00:00	AAPL	Stock	56.25	56.2775	56.155	56.1925	2786632.0
2018-09-28 14:30:00	AAPL	Stock	56.1938	56.355	56.18	56.3525	3297268.0
2018-09-28 15:00:00	AAPL	Stock	56.35	56.38	56.235	56.2675	3329564.0
2018-09-28 15:30:00	AAPL	Stock	56.2675	56.46	56.2325	56.44	10085448.0
2018-09-28 16:00:00	AAPL	Stock	56.435	56.4725	56.42	56.44	12077464.0
2018-09-28 16:30:00	AAPL	Stock	56.455	56.49	56.435	56.4875	690108.0
2018-09-28 17:00:00	AAPL	Stock	56.475	56.4875	56.455	56.455	25676.0
2018-09-28 17:30:00	AAPL	Stock	56.4625	56.4825	56.4625	56.48	25688.0
2018-09-28 18:00:00	AAPL	Stock	56.48	56.4925	56.435	56.4775	704868.0
2018-09-28 18:30:00	AAPL	Stock	56.4875	56.4875	56.475	56.475	7456.0
2018-09-28 19:00:00	AAPL	Stock	56.475	56.475	56.47	56.475	4480.0
2018-09-28 19:30:00	AAPL	Stock	56.47	56.4875	56.4675	56.4825	36212.0
2018-09-28 05:30:00	MSFT	Stock	114.4	114.4	114.4	114.4	200.0
2018-09-28 06:00:00	MSFT	Stock	114.4	114.4	114.39	114.39	1050.0
2018-09-28 06:30:00	MSFT	Stock	114.21	114.25	114.21	114.25	213.0
2018-09-28 07:00:00	MSFT	Stock	114.11	114.11	114.0	114.04	5388.0
2018-09-28 07:30:00	MSFT	Stock	114.03	114.04	113.93	114.0	20679.0
2018-09-28 08:00:00	MSFT	Stock	114.2	114.2	113.92	114.03	12847.0
2018-09-28 08:30:00	MSFT	Stock	114.03	114.09	114.0	114.05	14871.0
2018-09-28 09:00:00	MSFT	Stock	114.1	114.18	114.0	114.18	10659.0
2018-09-28 09:30:00	MSFT	Stock	114.19	114.495	113.79	114.01	1850812.0
2018-09-28 10:00:00	MSFT	Stock	114.0	114.19	113.68	113.84	1405971.0
2018-09-28 10:30:00	MSFT	Stock	113.83	114.289	113.75	114.239	1333822.0
2018-09-28 11:00:00	MSFT	Stock	114.24	114.46	114.19	114.315	850200.0
2018-09-28 11:30:00	MSFT	Stock	114.32	114.35	114.15	114.17	592491.0
2018-09-28 12:00:00	MSFT	Stock	114.16	114.3	114.01	114.057	395271.0
2018-09-28 12:30:00	MSFT	Stock	114.058	114.24	114.04	114.222	729314.0
2018-09-28 13:00:00	MSFT	Stock	114.22	114.35	114.18	114.34	489148.0
2018-09-28 13:30:00	MSFT	Stock	114.34	114.35	114.195	114.23	488912.0
2018-09-28 14:00:00	MSFT	Stock	114.23	114.24	113.97	114.19	548762.0

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

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