PREVIEW / stock_30min / 2019-03-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-15.parquet
  size:    1.7 MB
  rows:    85,607
  symbols: 2,652

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-15 04:00:00	AAPL	Stock	46.0625	46.125	46.0625	46.125	10092.0
2019-03-15 04:30:00	AAPL	Stock	46.1575	46.3325	46.1575	46.175	62912.0
2019-03-15 05:00:00	AAPL	Stock	46.1725	46.1725	46.125	46.1425	11368.0
2019-03-15 05:30:00	AAPL	Stock	46.1475	46.175	46.1475	46.175	9272.0
2019-03-15 06:00:00	AAPL	Stock	46.175	46.175	46.1675	46.1675	7088.0
2019-03-15 06:30:00	AAPL	Stock	46.225	46.2925	46.225	46.285	11020.0
2019-03-15 07:00:00	AAPL	Stock	46.28	46.28	46.18	46.225	125644.0
2019-03-15 07:30:00	AAPL	Stock	46.2275	46.25	46.225	46.225	40172.0
2019-03-15 08:00:00	AAPL	Stock	46.2495	46.3125	46.05	46.2625	245604.0
2019-03-15 08:30:00	AAPL	Stock	46.275	46.275	46.1425	46.1625	176788.0
2019-03-15 09:00:00	AAPL	Stock	46.1625	46.2125	46.075	46.1975	285056.0
2019-03-15 09:30:00	AAPL	Stock	46.195	46.2475	45.935	46.2275	35945444.0
2019-03-15 10:00:00	AAPL	Stock	46.2275	46.335	46.1075	46.3125	9444748.0
2019-03-15 10:30:00	AAPL	Stock	46.3125	46.4175	46.2275	46.41	6890696.0
2019-03-15 11:00:00	AAPL	Stock	46.4125	46.6225	46.38	46.5525	9006488.0
2019-03-15 11:30:00	AAPL	Stock	46.556	46.6275	46.5262	46.6025	6007820.0
2019-03-15 12:00:00	AAPL	Stock	46.6025	46.745	46.57	46.6725	6025196.0
2019-03-15 12:30:00	AAPL	Stock	46.672	46.7025	46.595	46.6112	5930796.0
2019-03-15 13:00:00	AAPL	Stock	46.615	46.69	46.6075	46.68	3859528.0
2019-03-15 13:30:00	AAPL	Stock	46.6775	46.8125	46.6675	46.7962	4730036.0
2019-03-15 14:00:00	AAPL	Stock	46.795	46.8025	46.67	46.7625	5898308.0
2019-03-15 14:30:00	AAPL	Stock	46.765	46.795	46.7225	46.7775	3770216.0
2019-03-15 15:00:00	AAPL	Stock	46.7775	46.8325	46.735	46.75	5438960.0
2019-03-15 15:30:00	AAPL	Stock	46.7475	46.7725	46.4725	46.5525	16889348.0
2019-03-15 16:00:00	AAPL	Stock	46.53	46.6178	46.4925	46.5125	18256364.0
2019-03-15 16:30:00	AAPL	Stock	46.5125	46.53	46.5	46.505	77052.0
2019-03-15 17:00:00	AAPL	Stock	46.505	46.5075	46.4825	46.5	54584.0
2019-03-15 17:30:00	AAPL	Stock	46.495	46.5	46.475	46.475	24204.0
2019-03-15 18:00:00	AAPL	Stock	46.465	46.465	46.445	46.4475	5968.0
2019-03-15 18:30:00	AAPL	Stock	46.46	46.4875	46.46	46.4825	11720.0
2019-03-15 19:00:00	AAPL	Stock	46.4875	46.4875	46.475	46.4875	20276.0
2019-03-15 19:30:00	AAPL	Stock	46.4875	46.4875	46.47	46.47	23996.0
2019-03-15 04:00:00	MSFT	Stock	115.17	115.17	114.58	114.58	200.0
2019-03-15 05:00:00	MSFT	Stock	114.66	114.74	114.6	114.6	1997.0
2019-03-15 05:30:00	MSFT	Stock	114.62	115.02	114.62	115.02	329.0
2019-03-15 06:00:00	MSFT	Stock	115.03	115.3	115.03	115.29	986.0
2019-03-15 06:30:00	MSFT	Stock	115.26	115.35	115.26	115.35	3100.0
2019-03-15 07:00:00	MSFT	Stock	115.35	115.38	115.3	115.3	1600.0
2019-03-15 07:30:00	MSFT	Stock	115.3	115.33	115.2	115.21	3238.0
2019-03-15 08:00:00	MSFT	Stock	115.431	115.431	115.11	115.2	18322.0
2019-03-15 08:30:00	MSFT	Stock	115.29	115.3	115.0	115.02	6170.0
2019-03-15 09:00:00	MSFT	Stock	115.03	115.41	114.85	115.34	43733.0
2019-03-15 09:30:00	MSFT	Stock	115.3	115.88	114.71	115.85	11901642.0
2019-03-15 10:00:00	MSFT	Stock	115.84	116.21	115.54	116.205	2238744.0
2019-03-15 10:30:00	MSFT	Stock	116.21	116.72	116.09	116.67	2103416.0
2019-03-15 11:00:00	MSFT	Stock	116.675	117.07	116.511	117.014	2003948.0
2019-03-15 11:30:00	MSFT	Stock	117.015	117.06	116.67	116.74	2028715.0
2019-03-15 12:00:00	MSFT	Stock	116.745	117.17	116.64	117.152	1737024.0
2019-03-15 12:30:00	MSFT	Stock	117.16	117.25	116.93	116.97	1145130.0
2019-03-15 13:00:00	MSFT	Stock	116.98	117.09	116.85	116.97	1099719.0

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

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