PREVIEW / stock_30min / 2016-01-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-25.parquet
  size:    1.6 MB
  rows:    82,491
  symbols: 3,383

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-01-25 04:00:00	AAPL	Stock	25.5	25.5	25.275	25.375	33008.0
2016-01-25 04:30:00	AAPL	Stock	25.425	25.425	25.425	25.425	400.0
2016-01-25 05:00:00	AAPL	Stock	25.425	25.4875	25.4025	25.45	15920.0
2016-01-25 05:30:00	AAPL	Stock	25.4125	25.45	25.4	25.45	5056.0
2016-01-25 06:00:00	AAPL	Stock	25.4725	25.4725	25.4375	25.4375	4840.0
2016-01-25 06:30:00	AAPL	Stock	25.4125	25.425	25.3625	25.42	73796.0
2016-01-25 07:00:00	AAPL	Stock	25.4	25.4125	25.33	25.355	75052.0
2016-01-25 07:30:00	AAPL	Stock	25.3375	25.3625	25.3325	25.3375	35036.0
2016-01-25 08:00:00	AAPL	Stock	25.35	25.4625	25.3	25.305	292020.0
2016-01-25 08:30:00	AAPL	Stock	25.32	25.37	25.21	25.2375	467528.0
2016-01-25 09:00:00	AAPL	Stock	25.2425	25.43	25.2125	25.39	1202292.0
2016-01-25 09:30:00	AAPL	Stock	25.38	25.3825	25.03	25.2325	30507964.0
2016-01-25 10:00:00	AAPL	Stock	25.2275	25.3612	25.1775	25.2405	18747756.0
2016-01-25 10:30:00	AAPL	Stock	25.2412	25.301	25.0975	25.2025	11902156.0
2016-01-25 11:00:00	AAPL	Stock	25.2	25.2025	25.09	25.1525	10240436.0
2016-01-25 11:30:00	AAPL	Stock	25.155	25.18	25.0575	25.12	8538784.0
2016-01-25 12:00:00	AAPL	Stock	25.1225	25.15	25.0675	25.07	9308200.0
2016-01-25 12:30:00	AAPL	Stock	25.0675	25.3025	25.0625	25.21	10596632.0
2016-01-25 13:00:00	AAPL	Stock	25.21	25.275	25.1825	25.1898	6347596.0
2016-01-25 13:30:00	AAPL	Stock	25.19	25.2225	25.1225	25.1225	8600676.0
2016-01-25 14:00:00	AAPL	Stock	25.125	25.145	25.075	25.1325	7206176.0
2016-01-25 14:30:00	AAPL	Stock	25.1325	25.1425	25.0875	25.1025	7087220.0
2016-01-25 15:00:00	AAPL	Stock	25.1025	25.1275	24.9412	24.9525	13737720.0
2016-01-25 15:30:00	AAPL	Stock	24.95	24.985	24.8025	24.8665	23864244.0
2016-01-25 16:00:00	AAPL	Stock	24.8575	25.2345	24.81	24.85	18372908.0
2016-01-25 16:30:00	AAPL	Stock	24.85	24.8625	24.8375	24.8625	112276.0
2016-01-25 17:00:00	AAPL	Stock	24.8575	24.87	24.8	24.825	126336.0
2016-01-25 17:30:00	AAPL	Stock	24.8175	24.8475	24.775	24.84	99508.0
2016-01-25 18:00:00	AAPL	Stock	24.825	24.85	24.8025	24.8225	28720.0
2016-01-25 18:30:00	AAPL	Stock	24.85	24.885	24.8425	24.875	36028.0
2016-01-25 19:00:00	AAPL	Stock	24.85	24.85	24.8	24.8325	51584.0
2016-01-25 19:30:00	AAPL	Stock	24.8325	24.8625	24.805	24.8625	101216.0
2016-01-25 04:00:00	MSFT	Stock	52.1	52.1	52.1	52.1	2000.0
2016-01-25 04:30:00	MSFT	Stock	52.1	52.1	52.1	52.1	1400.0
2016-01-25 06:30:00	MSFT	Stock	52.06	52.06	52.05	52.05	851.0
2016-01-25 07:00:00	MSFT	Stock	52.3	52.3	52.25	52.25	2947.0
2016-01-25 07:30:00	MSFT	Stock	52.2	52.2	52.2	52.2	500.0
2016-01-25 08:00:00	MSFT	Stock	52.1	52.3	52.06	52.06	6295.0
2016-01-25 08:30:00	MSFT	Stock	52.06	52.1	51.95	51.96	12584.0
2016-01-25 09:00:00	MSFT	Stock	51.97	52.05	51.92	51.92	33378.0
2016-01-25 09:30:00	MSFT	Stock	51.92	52.13	51.77	52.07	3776057.0
2016-01-25 10:00:00	MSFT	Stock	52.06	52.225	51.89	52.03	2212748.0
2016-01-25 10:30:00	MSFT	Stock	52.03	52.23	51.99	52.18	1995672.0
2016-01-25 11:00:00	MSFT	Stock	52.17	52.24	52.0	52.213	1836856.0
2016-01-25 11:30:00	MSFT	Stock	52.21	52.224	52.03	52.115	1201929.0
2016-01-25 12:00:00	MSFT	Stock	52.11	52.22	52.08	52.195	1244389.0
2016-01-25 12:30:00	MSFT	Stock	52.19	52.48	52.13	52.44	1784624.0
2016-01-25 13:00:00	MSFT	Stock	52.45	52.65	52.45	52.505	1748666.0
2016-01-25 13:30:00	MSFT	Stock	52.505	52.59	52.31	52.33	1335091.0
2016-01-25 14:00:00	MSFT	Stock	52.33	52.47	52.27	52.43	1388687.0

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

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