PREVIEW / stock_30min / 2018-11-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-27.parquet
  size:    1.7 MB
  rows:    82,343
  symbols: 2,737

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-27 04:00:00	AAPL	Stock	42.9375	43.1225	42.9375	43.1225	20788.0
2018-11-27 04:30:00	AAPL	Stock	43.21	43.21	43.0375	43.0375	15728.0
2018-11-27 05:00:00	AAPL	Stock	42.975	42.975	42.9025	42.97	15632.0
2018-11-27 05:30:00	AAPL	Stock	42.97	42.97	42.925	42.9475	5712.0
2018-11-27 06:00:00	AAPL	Stock	42.9	42.9	42.85	42.875	34732.0
2018-11-27 06:30:00	AAPL	Stock	42.9	43.0	42.8375	43.0	27108.0
2018-11-27 07:00:00	AAPL	Stock	42.9575	42.9775	42.7	42.81	231748.0
2018-11-27 07:30:00	AAPL	Stock	42.815	42.8675	42.7075	42.775	187756.0
2018-11-27 08:00:00	AAPL	Stock	42.7092	42.95	42.6925	42.845	1052644.0
2018-11-27 08:30:00	AAPL	Stock	42.835	43.025	42.775	42.95	677020.0
2018-11-27 09:00:00	AAPL	Stock	42.915	43.055	42.845	42.855	825544.0
2018-11-27 09:30:00	AAPL	Stock	42.865	43.295	42.72	43.185	28465068.0
2018-11-27 10:00:00	AAPL	Stock	43.1825	43.625	43.04	43.3575	19046400.0
2018-11-27 10:30:00	AAPL	Stock	43.36	43.6675	43.2125	43.5525	11348264.0
2018-11-27 11:00:00	AAPL	Stock	43.5475	43.6925	43.3808	43.4775	9907288.0
2018-11-27 11:30:00	AAPL	Stock	43.475	43.5425	43.33	43.502	5614992.0
2018-11-27 12:00:00	AAPL	Stock	43.5	43.5112	43.22	43.2625	5502088.0
2018-11-27 12:30:00	AAPL	Stock	43.2675	43.3525	43.1025	43.2075	5727060.0
2018-11-27 13:00:00	AAPL	Stock	43.2125	43.4	43.1425	43.2463	6507304.0
2018-11-27 13:30:00	AAPL	Stock	43.248	43.445	43.2375	43.44	5477688.0
2018-11-27 14:00:00	AAPL	Stock	43.4425	43.56	43.375	43.4675	5382548.0
2018-11-27 14:30:00	AAPL	Stock	43.47	43.4825	43.27	43.275	5420876.0
2018-11-27 15:00:00	AAPL	Stock	43.2725	43.4025	43.2175	43.3825	6866288.0
2018-11-27 15:30:00	AAPL	Stock	43.3875	43.575	43.315	43.5625	11755844.0
2018-11-27 16:00:00	AAPL	Stock	43.56	43.6125	43.5425	43.61	11968204.0
2018-11-27 16:30:00	AAPL	Stock	43.6125	43.7	43.56	43.695	831164.0
2018-11-27 17:00:00	AAPL	Stock	43.7	43.9	43.6875	43.86	248364.0
2018-11-27 17:30:00	AAPL	Stock	43.845	43.875	43.7725	43.79	189224.0
2018-11-27 18:00:00	AAPL	Stock	43.7875	43.9	43.7875	43.875	151980.0
2018-11-27 18:30:00	AAPL	Stock	43.875	43.8875	43.855	43.8875	121820.0
2018-11-27 19:00:00	AAPL	Stock	43.8875	43.9675	43.8775	43.9225	101236.0
2018-11-27 19:30:00	AAPL	Stock	43.925	43.9525	43.8875	43.9225	134976.0
2018-11-27 04:00:00	MSFT	Stock	106.82	107.0	106.7	106.8	12896.0
2018-11-27 04:30:00	MSFT	Stock	106.8	106.8	106.52	106.52	1200.0
2018-11-27 05:00:00	MSFT	Stock	106.5	106.79	106.5	106.79	3502.0
2018-11-27 05:30:00	MSFT	Stock	106.5	106.5	106.5	106.5	500.0
2018-11-27 06:00:00	MSFT	Stock	106.3	106.3	106.3	106.3	450.0
2018-11-27 07:00:00	MSFT	Stock	106.58	106.58	106.0	106.0	4276.0
2018-11-27 07:30:00	MSFT	Stock	105.97	106.15	105.82	106.0	6924.0
2018-11-27 08:00:00	MSFT	Stock	106.02	106.3	105.91	106.12	21838.0
2018-11-27 08:30:00	MSFT	Stock	106.18	106.5	106.18	106.27	16850.0
2018-11-27 09:00:00	MSFT	Stock	106.4	106.45	106.05	106.27	15413.0
2018-11-27 09:30:00	MSFT	Stock	106.28	106.5	105.36	106.39	3125733.0
2018-11-27 10:00:00	MSFT	Stock	106.38	107.04	106.03	106.39	3072472.0
2018-11-27 10:30:00	MSFT	Stock	106.39	106.77	106.125	106.62	1730156.0
2018-11-27 11:00:00	MSFT	Stock	106.61	107.17	106.56	106.94	1698209.0
2018-11-27 11:30:00	MSFT	Stock	106.94	107.03	106.51	106.935	1272219.0
2018-11-27 12:00:00	MSFT	Stock	106.94	106.98	106.3	106.36	1022007.0
2018-11-27 12:30:00	MSFT	Stock	106.35	106.67	106.1	106.18	1255843.0
2018-11-27 13:00:00	MSFT	Stock	106.18	106.57	106.0	106.39	1836192.0

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

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