PREVIEW / stock_30min / 2019-03-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-27.parquet
  size:    1.7 MB
  rows:    84,598
  symbols: 2,642

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
2019-03-27 04:00:00	AAPL	Stock	46.9625	47.22	46.9625	47.19	11520.0
2019-03-27 04:30:00	AAPL	Stock	47.1275	47.1275	47.065	47.065	800.0
2019-03-27 05:30:00	AAPL	Stock	47.1	47.1	46.9625	46.9625	10340.0
2019-03-27 06:00:00	AAPL	Stock	46.915	46.915	46.8375	46.875	3600.0
2019-03-27 06:30:00	AAPL	Stock	46.95	46.95	46.9075	46.9375	10268.0
2019-03-27 07:00:00	AAPL	Stock	46.9425	47.0	46.875	46.96	82492.0
2019-03-27 07:30:00	AAPL	Stock	46.9925	47.0975	46.975	47.09	111088.0
2019-03-27 08:00:00	AAPL	Stock	46.95	47.1475	46.8125	47.1075	270884.0
2019-03-27 08:30:00	AAPL	Stock	47.0875	47.2	47.075	47.0925	187280.0
2019-03-27 09:00:00	AAPL	Stock	47.1125	47.225	47.065	47.2	217272.0
2019-03-27 09:30:00	AAPL	Stock	47.1875	47.41	47.0725	47.13	19104052.0
2019-03-27 10:00:00	AAPL	Stock	47.13	47.42	47.0475	47.374	11192612.0
2019-03-27 10:30:00	AAPL	Stock	47.375	47.44	47.08	47.24	9548892.0
2019-03-27 11:00:00	AAPL	Stock	47.24	47.2712	46.82	46.8525	8098880.0
2019-03-27 11:30:00	AAPL	Stock	46.8475	46.885	46.6375	46.83	8037096.0
2019-03-27 12:00:00	AAPL	Stock	46.8275	47.095	46.8112	47.0725	6428868.0
2019-03-27 12:30:00	AAPL	Stock	47.0725	47.145	46.955	46.995	4517476.0
2019-03-27 13:00:00	AAPL	Stock	47.0025	47.2625	46.9075	47.2275	5185056.0
2019-03-27 13:30:00	AAPL	Stock	47.23	47.3162	47.1812	47.2125	3705108.0
2019-03-27 14:00:00	AAPL	Stock	47.2175	47.3375	47.17	47.22	4135996.0
2019-03-27 14:30:00	AAPL	Stock	47.2175	47.265	47.05	47.065	4482344.0
2019-03-27 15:00:00	AAPL	Stock	47.065	47.1475	47.0225	47.1375	4164192.0
2019-03-27 15:30:00	AAPL	Stock	47.1375	47.2175	47.0225	47.1175	8952160.0
2019-03-27 16:00:00	AAPL	Stock	47.1175	47.205	47.1175	47.18	9557944.0
2019-03-27 16:30:00	AAPL	Stock	47.1675	47.18	47.1175	47.1375	46976.0
2019-03-27 17:00:00	AAPL	Stock	47.1175	47.1375	47.1	47.12	24540.0
2019-03-27 17:30:00	AAPL	Stock	47.1275	47.1275	47.1125	47.1125	7356.0
2019-03-27 18:00:00	AAPL	Stock	47.1125	47.125	47.0	47.0	80292.0
2019-03-27 18:30:00	AAPL	Stock	47.0175	47.0475	47.0	47.0125	4548.0
2019-03-27 19:00:00	AAPL	Stock	47.0375	47.055	47.0125	47.0125	10464.0
2019-03-27 19:30:00	AAPL	Stock	47.01	47.05	47.0	47.045	43880.0
2019-03-27 04:00:00	MSFT	Stock	118.15	118.15	118.0	118.0	950.0
2019-03-27 04:30:00	MSFT	Stock	118.32	118.32	118.32	118.32	280.0
2019-03-27 05:00:00	MSFT	Stock	118.25	118.25	118.22	118.22	200.0
2019-03-27 05:30:00	MSFT	Stock	118.16	118.16	118.16	118.16	200.0
2019-03-27 06:00:00	MSFT	Stock	117.71	117.71	117.71	117.71	200.0
2019-03-27 06:30:00	MSFT	Stock	117.86	117.86	117.86	117.86	200.0
2019-03-27 07:00:00	MSFT	Stock	117.41	117.41	117.41	117.41	450.0
2019-03-27 07:30:00	MSFT	Stock	117.52	117.83	117.52	117.83	1108.0
2019-03-27 08:00:00	MSFT	Stock	117.49	117.84	117.49	117.8	1083.0
2019-03-27 08:30:00	MSFT	Stock	117.78	117.95	117.78	117.8	4779.0
2019-03-27 09:00:00	MSFT	Stock	117.9	118.05	117.75	118.02	6490.0
2019-03-27 09:30:00	MSFT	Stock	118.02	118.21	117.4	117.47	2040445.0
2019-03-27 10:00:00	MSFT	Stock	117.46	117.605	117.16	117.47	1513522.0
2019-03-27 10:30:00	MSFT	Stock	117.465	117.603	116.67	116.88	1434666.0
2019-03-27 11:00:00	MSFT	Stock	116.88	117.025	115.96	115.99	1742409.0
2019-03-27 11:30:00	MSFT	Stock	115.97	116.12	115.522	115.755	1998287.0
2019-03-27 12:00:00	MSFT	Stock	115.74	116.16	115.65	116.04	1143286.0
2019-03-27 12:30:00	MSFT	Stock	116.04	116.33	115.99	116.04	767893.0
2019-03-27 13:00:00	MSFT	Stock	116.04	116.71	115.94	116.67	848025.0

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

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