PREVIEW / stock_30min / 2016-05-03

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-03.parquet
  size:    1.6 MB
  rows:    81,548
  symbols: 3,302

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
2016-05-03 04:00:00	AAPL	Stock	23.455	23.455	23.325	23.325	21052.0
2016-05-03 04:30:00	AAPL	Stock	23.325	23.395	23.275	23.395	16432.0
2016-05-03 05:00:00	AAPL	Stock	23.35	23.35	23.295	23.295	4700.0
2016-05-03 05:30:00	AAPL	Stock	23.2925	23.295	23.2825	23.2825	7272.0
2016-05-03 06:00:00	AAPL	Stock	23.2775	23.295	23.27	23.295	13920.0
2016-05-03 06:30:00	AAPL	Stock	23.295	23.295	23.28	23.28	3200.0
2016-05-03 07:00:00	AAPL	Stock	23.3	23.35	23.2875	23.35	54396.0
2016-05-03 07:30:00	AAPL	Stock	23.3675	23.41	23.35	23.4025	345296.0
2016-05-03 08:00:00	AAPL	Stock	23.3875	23.475	23.275	23.445	738664.0
2016-05-03 08:30:00	AAPL	Stock	23.455	23.515	23.425	23.5	779352.0
2016-05-03 09:00:00	AAPL	Stock	23.4975	23.5525	23.4475	23.55	1166184.0
2016-05-03 09:30:00	AAPL	Stock	23.55	23.6225	23.4375	23.5	35234512.0
2016-05-03 10:00:00	AAPL	Stock	23.5	23.57	23.42	23.5188	21904720.0
2016-05-03 10:30:00	AAPL	Stock	23.52	23.5325	23.4328	23.4972	11832872.0
2016-05-03 11:00:00	AAPL	Stock	23.4975	23.5975	23.4625	23.565	13051996.0
2016-05-03 11:30:00	AAPL	Stock	23.565	23.72	23.525	23.655	16147508.0
2016-05-03 12:00:00	AAPL	Stock	23.657	23.685	23.5925	23.6848	9751740.0
2016-05-03 12:30:00	AAPL	Stock	23.6848	23.77	23.6558	23.765	13827232.0
2016-05-03 13:00:00	AAPL	Stock	23.765	23.88	23.74	23.8612	14671672.0
2016-05-03 13:30:00	AAPL	Stock	23.8625	23.935	23.795	23.8375	13736536.0
2016-05-03 14:00:00	AAPL	Stock	23.84	23.86	23.775	23.8225	10141316.0
2016-05-03 14:30:00	AAPL	Stock	23.825	23.8625	23.7725	23.82	8062756.0
2016-05-03 15:00:00	AAPL	Stock	23.8225	23.8925	23.7987	23.8525	11729964.0
2016-05-03 15:30:00	AAPL	Stock	23.8525	23.865	23.775	23.795	19699232.0
2016-05-03 16:00:00	AAPL	Stock	23.795	23.815	23.41	23.75	8602288.0
2016-05-03 16:30:00	AAPL	Stock	23.7625	23.795	23.75	23.7825	273080.0
2016-05-03 17:00:00	AAPL	Stock	23.7825	23.7875	23.7575	23.76	69960.0
2016-05-03 17:30:00	AAPL	Stock	23.7625	23.785	23.75	23.785	68492.0
2016-05-03 18:00:00	AAPL	Stock	23.78	23.795	23.7675	23.795	21700.0
2016-05-03 18:30:00	AAPL	Stock	23.795	23.795	23.775	23.7875	15968.0
2016-05-03 19:00:00	AAPL	Stock	23.7775	23.7875	23.7775	23.7775	12236.0
2016-05-03 19:30:00	AAPL	Stock	23.7875	23.7925	23.775	23.79	50256.0
2016-05-03 06:30:00	MSFT	Stock	50.37	50.37	50.37	50.37	500.0
2016-05-03 07:00:00	MSFT	Stock	50.25	50.28	50.16	50.2	1802.0
2016-05-03 08:00:00	MSFT	Stock	50.29	50.29	50.16	50.18	2716.0
2016-05-03 08:30:00	MSFT	Stock	50.27	50.34	50.27	50.34	21809.0
2016-05-03 09:00:00	MSFT	Stock	50.34	50.35	50.27	50.34	36660.0
2016-05-03 09:30:00	MSFT	Stock	50.34	50.41	49.87	50.05	2770025.0
2016-05-03 10:00:00	MSFT	Stock	50.044	50.044	49.72	49.91	2255738.0
2016-05-03 10:30:00	MSFT	Stock	49.915	50.09	49.85	49.93	1759260.0
2016-05-03 11:00:00	MSFT	Stock	49.93	50.025	49.8	49.83	1494227.0
2016-05-03 11:30:00	MSFT	Stock	49.83	49.91	49.71	49.77	1293360.0
2016-05-03 12:00:00	MSFT	Stock	49.76	49.82	49.64	49.81	1375317.0
2016-05-03 12:30:00	MSFT	Stock	49.81	49.96	49.81	49.91	1102745.0
2016-05-03 13:00:00	MSFT	Stock	49.91	50.03	49.83	50.015	1113512.0
2016-05-03 13:30:00	MSFT	Stock	50.015	50.05	49.93	49.96	1408262.0
2016-05-03 14:00:00	MSFT	Stock	49.96	50.005	49.75	49.88	1380831.0
2016-05-03 14:30:00	MSFT	Stock	49.88	49.92	49.72	49.815	1310953.0
2016-05-03 15:00:00	MSFT	Stock	49.82	49.87	49.71	49.76	1443041.0
2016-05-03 15:30:00	MSFT	Stock	49.76	49.81	49.6	49.78	3797447.0

> showing 50 of 81,548 rows — these rows as CSV

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