PREVIEW / stock_30min / 2018-05-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-11.parquet
  size:    1.6 MB
  rows:    82,694
  symbols: 2,852

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-05-11 04:00:00	AAPL	Stock	47.4	47.4	47.36	47.3625	5200.0
2018-05-11 04:30:00	AAPL	Stock	47.375	47.375	47.35	47.35	4928.0
2018-05-11 05:00:00	AAPL	Stock	47.35	47.375	47.35	47.35	16812.0
2018-05-11 05:30:00	AAPL	Stock	47.37	47.375	47.275	47.2775	10908.0
2018-05-11 06:00:00	AAPL	Stock	47.3625	47.4125	47.3625	47.4	9636.0
2018-05-11 06:30:00	AAPL	Stock	47.38	47.395	47.3625	47.375	104456.0
2018-05-11 07:00:00	AAPL	Stock	47.35	47.425	47.35	47.4175	68720.0
2018-05-11 07:30:00	AAPL	Stock	47.425	47.4725	47.4125	47.4375	137788.0
2018-05-11 08:00:00	AAPL	Stock	47.4125	47.45	47.3625	47.375	178732.0
2018-05-11 08:30:00	AAPL	Stock	47.375	47.395	47.3275	47.355	173200.0
2018-05-11 09:00:00	AAPL	Stock	47.36	47.375	47.32	47.3525	205276.0
2018-05-11 09:30:00	AAPL	Stock	47.3725	47.515	47.15	47.3812	14566684.0
2018-05-11 10:00:00	AAPL	Stock	47.3825	47.3975	47.27	47.32	6390560.0
2018-05-11 10:30:00	AAPL	Stock	47.3202	47.3625	47.245	47.31	5430236.0
2018-05-11 11:00:00	AAPL	Stock	47.31	47.3125	47.16	47.214	5488956.0
2018-05-11 11:30:00	AAPL	Stock	47.2125	47.2512	47.1075	47.25	4491432.0
2018-05-11 12:00:00	AAPL	Stock	47.2512	47.275	47.085	47.085	4176324.0
2018-05-11 12:30:00	AAPL	Stock	47.0825	47.17	47.0625	47.1375	3097964.0
2018-05-11 13:00:00	AAPL	Stock	47.1375	47.2	47.1	47.1775	2487168.0
2018-05-11 13:30:00	AAPL	Stock	47.1775	47.21	47.1275	47.16	2596004.0
2018-05-11 14:00:00	AAPL	Stock	47.1622	47.1725	47.0525	47.065	3708840.0
2018-05-11 14:30:00	AAPL	Stock	47.0625	47.07	46.8625	46.9175	6477872.0
2018-05-11 15:00:00	AAPL	Stock	46.915	47.075	46.9125	47.065	5105964.0
2018-05-11 15:30:00	AAPL	Stock	47.0625	47.1825	47.0575	47.1475	9014984.0
2018-05-11 16:00:00	AAPL	Stock	47.1475	47.1575	47.1275	47.15	13841008.0
2018-05-11 16:30:00	AAPL	Stock	47.155	47.175	47.1375	47.1575	292180.0
2018-05-11 17:00:00	AAPL	Stock	47.1425	47.175	47.14	47.165	34696.0
2018-05-11 17:30:00	AAPL	Stock	47.1575	47.1575	47.14	47.15	20212.0
2018-05-11 18:00:00	AAPL	Stock	47.15	47.15	47.14	47.15	14076.0
2018-05-11 18:30:00	AAPL	Stock	47.15	47.1625	47.15	47.1625	5584.0
2018-05-11 19:00:00	AAPL	Stock	47.155	47.1625	47.1475	47.1475	26804.0
2018-05-11 19:30:00	AAPL	Stock	47.15	47.15	47.1375	47.1375	81416.0
2018-05-11 04:00:00	MSFT	Stock	97.92	97.92	97.92	97.92	136.0
2018-05-11 06:00:00	MSFT	Stock	97.93	98.0	97.93	98.0	1500.0
2018-05-11 07:00:00	MSFT	Stock	97.89	97.99	97.87	97.99	950.0
2018-05-11 07:30:00	MSFT	Stock	98.0	98.12	97.99	98.05	4674.0
2018-05-11 08:00:00	MSFT	Stock	97.88	98.16	97.88	98.08	22851.0
2018-05-11 08:30:00	MSFT	Stock	98.03	98.08	97.87	97.94	9389.0
2018-05-11 09:00:00	MSFT	Stock	97.9	97.93	97.76	97.76	13021.0
2018-05-11 09:30:00	MSFT	Stock	97.69	97.87	97.04	97.49	1576834.0
2018-05-11 10:00:00	MSFT	Stock	97.48	97.85	97.48	97.655	1110003.0
2018-05-11 10:30:00	MSFT	Stock	97.655	97.81	97.44	97.77	948806.0
2018-05-11 11:00:00	MSFT	Stock	97.765	97.775	97.46	97.52	746609.0
2018-05-11 11:30:00	MSFT	Stock	97.52	97.58	97.34	97.515	754328.0
2018-05-11 12:00:00	MSFT	Stock	97.52	97.585	97.21	97.245	665385.0
2018-05-11 12:30:00	MSFT	Stock	97.25	97.4	97.21	97.365	619770.0
2018-05-11 13:00:00	MSFT	Stock	97.36	97.52	97.32	97.46	590136.0
2018-05-11 13:30:00	MSFT	Stock	97.46	97.465	97.252	97.356	405890.0
2018-05-11 14:00:00	MSFT	Stock	97.359	97.425	97.165	97.255	686952.0
2018-05-11 14:30:00	MSFT	Stock	97.25	97.3	97.09	97.18	730284.0

> showing 50 of 82,694 rows — these rows as CSV

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