PREVIEW / stock_30min / 2018-11-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-13.parquet
  size:    1.7 MB
  rows:    83,942
  symbols: 2,744

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-11-13 04:00:00	AAPL	Stock	48.795	48.795	48.625	48.7	17680.0
2018-11-13 04:30:00	AAPL	Stock	48.675	48.675	48.45	48.45	18708.0
2018-11-13 05:00:00	AAPL	Stock	48.475	48.475	48.4125	48.4525	7492.0
2018-11-13 05:30:00	AAPL	Stock	48.4375	48.56	48.4125	48.5375	28108.0
2018-11-13 06:00:00	AAPL	Stock	48.56	48.6975	48.5375	48.6375	89452.0
2018-11-13 06:30:00	AAPL	Stock	48.6175	48.6275	48.5	48.545	44724.0
2018-11-13 07:00:00	AAPL	Stock	48.545	48.58	48.3325	48.36	165368.0
2018-11-13 07:30:00	AAPL	Stock	48.35	48.425	48.225	48.2725	216652.0
2018-11-13 08:00:00	AAPL	Stock	48.5625	48.6095	48.0675	48.2	758792.0
2018-11-13 08:30:00	AAPL	Stock	48.2125	48.2125	47.875	48.005	823444.0
2018-11-13 09:00:00	AAPL	Stock	47.9925	48.135	47.795	47.9375	1217680.0
2018-11-13 09:30:00	AAPL	Stock	47.93	48.805	47.8625	48.0445	32300168.0
2018-11-13 10:00:00	AAPL	Stock	48.035	48.575	47.8975	48.2625	17933296.0
2018-11-13 10:30:00	AAPL	Stock	48.2525	48.97	48.2375	48.8825	14750952.0
2018-11-13 11:00:00	AAPL	Stock	48.8888	49.295	48.865	48.9125	13656756.0
2018-11-13 11:30:00	AAPL	Stock	48.9125	48.9875	48.6308	48.68	7436108.0
2018-11-13 12:00:00	AAPL	Stock	48.6925	48.81	48.55	48.6982	6190636.0
2018-11-13 12:30:00	AAPL	Stock	48.7008	48.705	48.375	48.45	6104876.0
2018-11-13 13:00:00	AAPL	Stock	48.445	48.6075	48.3925	48.4875	4836960.0
2018-11-13 13:30:00	AAPL	Stock	48.4925	48.7325	48.4375	48.4705	4817564.0
2018-11-13 14:00:00	AAPL	Stock	48.4688	48.49	48.1775	48.3378	6196008.0
2018-11-13 14:30:00	AAPL	Stock	48.34	48.4175	48.1425	48.265	4951068.0
2018-11-13 15:00:00	AAPL	Stock	48.265	48.445	48.1	48.12	7588480.0
2018-11-13 15:30:00	AAPL	Stock	48.1175	48.2425	47.9825	48.0575	15492148.0
2018-11-13 16:00:00	AAPL	Stock	48.0575	48.4692	48.0075	48.1025	8470380.0
2018-11-13 16:30:00	AAPL	Stock	48.1075	48.245	48.0575	48.2	291276.0
2018-11-13 17:00:00	AAPL	Stock	48.2375	48.2375	48.0575	48.185	56484.0
2018-11-13 17:30:00	AAPL	Stock	48.1625	48.2075	48.1625	48.2	30004.0
2018-11-13 18:00:00	AAPL	Stock	48.205	48.3875	48.1975	48.3875	176916.0
2018-11-13 18:30:00	AAPL	Stock	48.385	48.3875	48.3125	48.35	49892.0
2018-11-13 19:00:00	AAPL	Stock	48.325	48.375	48.325	48.375	26776.0
2018-11-13 19:30:00	AAPL	Stock	48.3575	48.3875	48.34	48.375	89232.0
2018-11-13 04:00:00	MSFT	Stock	107.6	107.6	107.6	107.6	700.0
2018-11-13 04:30:00	MSFT	Stock	107.6	107.6	107.6	107.6	167.0
2018-11-13 05:00:00	MSFT	Stock	107.33	107.33	107.33	107.33	100.0
2018-11-13 05:30:00	MSFT	Stock	107.39	107.6	107.39	107.6	1139.0
2018-11-13 06:30:00	MSFT	Stock	107.77	107.77	107.77	107.77	2741.0
2018-11-13 07:00:00	MSFT	Stock	107.9	107.97	107.67	107.82	7600.0
2018-11-13 07:30:00	MSFT	Stock	107.84	107.91	107.6	107.6	6447.0
2018-11-13 08:00:00	MSFT	Stock	107.9	107.95	107.4	107.65	15033.0
2018-11-13 08:30:00	MSFT	Stock	107.41	107.57	107.32	107.47	9592.0
2018-11-13 09:00:00	MSFT	Stock	107.49	107.6	107.32	107.55	15746.0
2018-11-13 09:30:00	MSFT	Stock	107.55	108.57	107.47	107.77	3238847.0
2018-11-13 10:00:00	MSFT	Stock	107.77	108.2	107.05	107.27	2911767.0
2018-11-13 10:30:00	MSFT	Stock	107.26	108.33	107.18	107.93	2597099.0
2018-11-13 11:00:00	MSFT	Stock	107.92	108.74	107.89	108.375	2485423.0
2018-11-13 11:30:00	MSFT	Stock	108.37	108.52	107.95	108.065	1383083.0
2018-11-13 12:00:00	MSFT	Stock	108.08	108.28	107.78	108.04	1201590.0
2018-11-13 12:30:00	MSFT	Stock	108.05	108.06	107.33	107.67	1276627.0
2018-11-13 13:00:00	MSFT	Stock	107.678	107.89	107.425	107.56	1228803.0

> showing 50 of 83,942 rows — these rows as CSV

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