PREVIEW / stock_30min / 2016-03-10

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-10.parquet
  size:    1.6 MB
  rows:    81,371
  symbols: 3,331

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-03-10 04:00:00	AAPL	Stock	25.3	25.365	25.3	25.365	2804.0
2016-03-10 04:30:00	AAPL	Stock	25.3	25.3	25.3	25.3	800.0
2016-03-10 06:00:00	AAPL	Stock	25.3225	25.3225	25.3225	25.3225	740.0
2016-03-10 06:30:00	AAPL	Stock	25.325	25.325	25.325	25.325	2000.0
2016-03-10 07:00:00	AAPL	Stock	25.3375	25.405	25.335	25.405	47728.0
2016-03-10 07:30:00	AAPL	Stock	25.4	25.56	25.395	25.55	151500.0
2016-03-10 08:00:00	AAPL	Stock	25.525	25.55	25.3625	25.5225	383576.0
2016-03-10 08:30:00	AAPL	Stock	25.5275	25.555	25.4525	25.475	265068.0
2016-03-10 09:00:00	AAPL	Stock	25.465	25.4975	25.35	25.36	360232.0
2016-03-10 09:30:00	AAPL	Stock	25.3525	25.56	25.3075	25.55	17172144.0
2016-03-10 10:00:00	AAPL	Stock	25.552	25.56	25.3525	25.37	10326100.0
2016-03-10 10:30:00	AAPL	Stock	25.3675	25.3775	25.19	25.205	10523456.0
2016-03-10 11:00:00	AAPL	Stock	25.2075	25.25	25.1125	25.175	8703332.0
2016-03-10 11:30:00	AAPL	Stock	25.1725	25.2825	25.1175	25.255	7305116.0
2016-03-10 12:00:00	AAPL	Stock	25.255	25.38	25.235	25.2825	9939644.0
2016-03-10 12:30:00	AAPL	Stock	25.2825	25.2825	25.075	25.11	8118576.0
2016-03-10 13:00:00	AAPL	Stock	25.1078	25.1775	25.0375	25.145	7631080.0
2016-03-10 13:30:00	AAPL	Stock	25.1475	25.1875	25.075	25.0925	5865532.0
2016-03-10 14:00:00	AAPL	Stock	25.095	25.1625	25.0725	25.1575	5666120.0
2016-03-10 14:30:00	AAPL	Stock	25.16	25.2825	25.1225	25.24	5813956.0
2016-03-10 15:00:00	AAPL	Stock	25.2395	25.3775	25.2075	25.345	7831524.0
2016-03-10 15:30:00	AAPL	Stock	25.345	25.36	25.21	25.2925	10395200.0
2016-03-10 16:00:00	AAPL	Stock	25.2925	25.4185	25.25	25.2575	6668748.0
2016-03-10 16:30:00	AAPL	Stock	25.2575	25.27	25.25	25.255	16548.0
2016-03-10 17:00:00	AAPL	Stock	25.26	25.29	25.2575	25.275	69620.0
2016-03-10 17:30:00	AAPL	Stock	25.28	25.28	25.2675	25.275	5640.0
2016-03-10 18:00:00	AAPL	Stock	25.2675	25.2675	25.2625	25.2625	7920.0
2016-03-10 18:30:00	AAPL	Stock	25.2725	25.285	25.265	25.265	14280.0
2016-03-10 19:00:00	AAPL	Stock	25.2825	25.285	25.27	25.28	7076.0
2016-03-10 19:30:00	AAPL	Stock	25.27	25.285	25.26	25.285	23856.0
2016-03-10 05:30:00	MSFT	Stock	52.85	52.85	52.84	52.84	200.0
2016-03-10 07:00:00	MSFT	Stock	52.94	52.96	52.94	52.96	1107.0
2016-03-10 07:30:00	MSFT	Stock	53.04	53.4	53.04	53.4	14371.0
2016-03-10 08:00:00	MSFT	Stock	53.13	53.6	53.1	53.3	17514.0
2016-03-10 08:30:00	MSFT	Stock	53.17	53.37	53.1	53.14	25568.0
2016-03-10 09:00:00	MSFT	Stock	53.14	53.18	52.95	52.95	23708.0
2016-03-10 09:30:00	MSFT	Stock	52.93	52.94	52.53	52.73	4124018.0
2016-03-10 10:00:00	MSFT	Stock	52.74	52.79	52.41	52.52	2799992.0
2016-03-10 10:30:00	MSFT	Stock	52.525	52.53	52.025	52.05	2422303.0
2016-03-10 11:00:00	MSFT	Stock	52.05	52.17	51.81	51.89	2784725.0
2016-03-10 11:30:00	MSFT	Stock	51.886	52.13	51.8	51.955	2438728.0
2016-03-10 12:00:00	MSFT	Stock	51.95	52.09	51.555	51.66	2210684.0
2016-03-10 12:30:00	MSFT	Stock	51.66	51.72	51.265	51.41	2477478.0
2016-03-10 13:00:00	MSFT	Stock	51.4	51.49	51.16	51.4	1992051.0
2016-03-10 13:30:00	MSFT	Stock	51.41	51.5	51.305	51.31	1991662.0
2016-03-10 14:00:00	MSFT	Stock	51.314	51.49	51.22	51.444	1605747.0
2016-03-10 14:30:00	MSFT	Stock	51.45	51.96	51.395	51.81	2268318.0
2016-03-10 15:00:00	MSFT	Stock	51.815	52.15	51.7	52.06	2404110.0
2016-03-10 15:30:00	MSFT	Stock	52.06	52.1	51.79	52.05	4224606.0
2016-03-10 16:00:00	MSFT	Stock	52.05	52.05	51.97	51.97	2267399.0

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

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