PREVIEW / stock_30min / 2018-04-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-03.parquet
  size:    1.7 MB
  rows:    83,432
  symbols: 2,879

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-04-03 04:00:00	AAPL	Stock	41.875	41.875	41.7	41.7	13612.0
2018-04-03 04:30:00	AAPL	Stock	41.8225	41.8225	41.8225	41.8225	900.0
2018-04-03 05:00:00	AAPL	Stock	41.775	41.775	41.775	41.775	800.0
2018-04-03 05:30:00	AAPL	Stock	41.805	41.84	41.775	41.775	5696.0
2018-04-03 06:00:00	AAPL	Stock	41.795	41.8125	41.7875	41.8125	3044.0
2018-04-03 06:30:00	AAPL	Stock	41.875	41.92	41.875	41.9	8436.0
2018-04-03 07:00:00	AAPL	Stock	41.845	41.85	41.8025	41.8375	129936.0
2018-04-03 07:30:00	AAPL	Stock	41.815	41.8625	41.7925	41.8625	40640.0
2018-04-03 08:00:00	AAPL	Stock	41.8625	41.985	41.67	41.9725	366140.0
2018-04-03 08:30:00	AAPL	Stock	41.9725	42.045	41.8875	42.025	232720.0
2018-04-03 09:00:00	AAPL	Stock	42.0225	42.0375	41.85	41.9225	557996.0
2018-04-03 09:30:00	AAPL	Stock	41.915	41.95	41.6025	41.675	15089260.0
2018-04-03 10:00:00	AAPL	Stock	41.68	41.6888	41.22	41.3375	10558040.0
2018-04-03 10:30:00	AAPL	Stock	41.335	41.6675	41.29	41.6175	10756960.0
2018-04-03 11:00:00	AAPL	Stock	41.6225	41.9	41.6138	41.685	7904180.0
2018-04-03 11:30:00	AAPL	Stock	41.68	41.745	41.425	41.425	5161588.0
2018-04-03 12:00:00	AAPL	Stock	41.43	41.5625	41.34	41.45	4323100.0
2018-04-03 12:30:00	AAPL	Stock	41.4475	41.6225	41.425	41.53	3581108.0
2018-04-03 13:00:00	AAPL	Stock	41.534	41.755	41.44	41.71	3749884.0
2018-04-03 13:30:00	AAPL	Stock	41.7175	41.7925	41.6062	41.7338	3315800.0
2018-04-03 14:00:00	AAPL	Stock	41.735	41.77	41.5175	41.56	3524900.0
2018-04-03 14:30:00	AAPL	Stock	41.5525	41.92	41.4025	41.8675	5568960.0
2018-04-03 15:00:00	AAPL	Stock	41.865	42.175	41.7925	42.17	11153852.0
2018-04-03 15:30:00	AAPL	Stock	42.17	42.1865	41.9675	42.0975	9864068.0
2018-04-03 16:00:00	AAPL	Stock	42.0975	42.135	42.075	42.115	8872160.0
2018-04-03 16:30:00	AAPL	Stock	42.1225	42.1225	42.0975	42.1	53076.0
2018-04-03 17:00:00	AAPL	Stock	42.1	42.1125	42.085	42.085	20876.0
2018-04-03 17:30:00	AAPL	Stock	42.0875	42.0875	42.0025	42.0125	49036.0
2018-04-03 18:00:00	AAPL	Stock	42.0125	42.0475	42.005	42.025	18608.0
2018-04-03 18:30:00	AAPL	Stock	42.0125	42.0475	42.0	42.0025	17208.0
2018-04-03 19:00:00	AAPL	Stock	42.0075	42.0375	42.0075	42.0375	6600.0
2018-04-03 19:30:00	AAPL	Stock	42.0125	42.025	41.925	42.0	35168.0
2018-04-03 04:00:00	MSFT	Stock	88.95	88.95	88.95	88.95	500.0
2018-04-03 05:00:00	MSFT	Stock	89.16	89.28	89.16	89.28	700.0
2018-04-03 06:30:00	MSFT	Stock	89.17	89.17	89.14	89.14	800.0
2018-04-03 07:00:00	MSFT	Stock	89.05	89.3	89.0	89.02	6232.0
2018-04-03 07:30:00	MSFT	Stock	89.02	89.25	89.02	89.18	4927.0
2018-04-03 08:00:00	MSFT	Stock	89.1	89.6	88.52	88.52	38693.0
2018-04-03 08:30:00	MSFT	Stock	89.5	89.6	89.4	89.52	84058.0
2018-04-03 09:00:00	MSFT	Stock	89.52	89.74	89.42	89.65	82941.0
2018-04-03 09:30:00	MSFT	Stock	89.575	89.91	88.33	88.48	3999183.0
2018-04-03 10:00:00	MSFT	Stock	88.48	88.71	87.89	88.703	2280922.0
2018-04-03 10:30:00	MSFT	Stock	88.7	89.54	88.64	89.46	3761039.0
2018-04-03 11:00:00	MSFT	Stock	89.46	90.05	89.44	89.45	2687826.0
2018-04-03 11:30:00	MSFT	Stock	89.45	89.54	88.62	88.64	1586134.0
2018-04-03 12:00:00	MSFT	Stock	88.65	88.95	88.2	88.43	1254102.0
2018-04-03 12:30:00	MSFT	Stock	88.43	88.98	88.375	88.59	1175069.0
2018-04-03 13:00:00	MSFT	Stock	88.6	89.16	88.39	88.97	1198212.0
2018-04-03 13:30:00	MSFT	Stock	88.98	89.23	88.764	89.055	1133778.0
2018-04-03 14:00:00	MSFT	Stock	89.06	89.21	88.37	88.51	1436976.0

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

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