PREVIEW / stock_30min / 2020-02-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-06.parquet
  size:    1.8 MB
  rows:    86,713
  symbols: 2,416

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
2020-02-06 04:00:00	AAPL	Stock	80.775	81.095	80.775	80.8	28824.0
2020-02-06 04:30:00	AAPL	Stock	80.85	80.86	80.6975	80.6975	9960.0
2020-02-06 05:00:00	AAPL	Stock	80.675	80.775	80.675	80.775	7292.0
2020-02-06 05:30:00	AAPL	Stock	80.745	80.7625	80.6875	80.7625	3840.0
2020-02-06 06:30:00	AAPL	Stock	80.75	80.875	80.75	80.875	34452.0
2020-02-06 07:00:00	AAPL	Stock	80.845	80.9925	80.8	80.81	82576.0
2020-02-06 07:30:00	AAPL	Stock	80.79	80.875	80.72	80.75	75132.0
2020-02-06 08:00:00	AAPL	Stock	80.925	80.9825	80.68	80.7825	422388.0
2020-02-06 08:30:00	AAPL	Stock	80.7875	80.87	80.575	80.6695	146604.0
2020-02-06 09:00:00	AAPL	Stock	80.6625	80.74	80.5838	80.6375	154392.0
2020-02-06 09:30:00	AAPL	Stock	80.6125	80.9225	80.0662	80.595	11600708.0
2020-02-06 10:00:00	AAPL	Stock	80.5925	80.625	80.0925	80.13	6650936.0
2020-02-06 10:30:00	AAPL	Stock	80.13	80.545	80.0975	80.422	5085988.0
2020-02-06 11:00:00	AAPL	Stock	80.425	80.655	80.33	80.6275	4453304.0
2020-02-06 11:30:00	AAPL	Stock	80.6275	80.7125	80.4075	80.4125	3831884.0
2020-02-06 12:00:00	AAPL	Stock	80.4112	80.7675	80.385	80.7625	3894132.0
2020-02-06 12:30:00	AAPL	Stock	80.765	80.895	80.6825	80.8788	3914440.0
2020-02-06 13:00:00	AAPL	Stock	80.875	81.0	80.84	80.9225	4372208.0
2020-02-06 13:30:00	AAPL	Stock	80.9238	81.175	80.9115	81.145	4959684.0
2020-02-06 14:00:00	AAPL	Stock	81.148	81.2475	81.0	81.1538	5073044.0
2020-02-06 14:30:00	AAPL	Stock	81.1582	81.25	81.125	81.1288	4065016.0
2020-02-06 15:00:00	AAPL	Stock	81.1325	81.17	80.98	81.0375	4681224.0
2020-02-06 15:30:00	AAPL	Stock	81.0325	81.305	81.03	81.3025	9781040.0
2020-02-06 16:00:00	AAPL	Stock	81.3025	81.3375	81.2925	81.3275	7594424.0
2020-02-06 16:30:00	AAPL	Stock	81.3275	81.3625	81.3025	81.335	143828.0
2020-02-06 17:00:00	AAPL	Stock	81.335	81.4	81.335	81.3975	154056.0
2020-02-06 17:30:00	AAPL	Stock	81.3775	81.4325	81.3775	81.3875	39456.0
2020-02-06 18:00:00	AAPL	Stock	81.41	81.4325	81.39	81.4125	53868.0
2020-02-06 18:30:00	AAPL	Stock	81.39	81.4275	81.39	81.42	39584.0
2020-02-06 19:00:00	AAPL	Stock	81.42	81.425	81.39	81.3925	29628.0
2020-02-06 19:30:00	AAPL	Stock	81.4	81.425	81.2275	81.375	390464.0
2020-02-06 04:00:00	MSFT	Stock	181.01	182.39	181.01	181.52	6123.0
2020-02-06 04:30:00	MSFT	Stock	181.5	181.69	181.4	181.55	3216.0
2020-02-06 05:00:00	MSFT	Stock	181.5	181.5	181.45	181.45	600.0
2020-02-06 05:30:00	MSFT	Stock	181.66	181.67	181.66	181.66	2895.0
2020-02-06 06:00:00	MSFT	Stock	181.5	181.51	181.46	181.51	650.0
2020-02-06 06:30:00	MSFT	Stock	181.51	181.93	181.51	181.78	5326.0
2020-02-06 07:00:00	MSFT	Stock	181.72	181.95	181.5	181.5	17465.0
2020-02-06 07:30:00	MSFT	Stock	181.4	181.59	181.11	181.3	17490.0
2020-02-06 08:00:00	MSFT	Stock	181.79	181.9	180.864	181.3	54263.0
2020-02-06 08:30:00	MSFT	Stock	181.31	181.54	180.83	181.0	30017.0
2020-02-06 09:00:00	MSFT	Stock	181.0	181.284	180.8	180.97	50136.0
2020-02-06 09:30:00	MSFT	Stock	180.97	181.95	180.059	181.95	3550035.0
2020-02-06 10:00:00	MSFT	Stock	181.94	182.4	181.205	181.4	2072036.0
2020-02-06 10:30:00	MSFT	Stock	181.4	182.13	181.33	182.005	1213454.0
2020-02-06 11:00:00	MSFT	Stock	182.01	182.93	181.92	182.91	1401812.0
2020-02-06 11:30:00	MSFT	Stock	182.905	182.98	182.21	182.212	1139850.0
2020-02-06 12:00:00	MSFT	Stock	182.21	182.86	182.19	182.86	1020682.0
2020-02-06 12:30:00	MSFT	Stock	182.86	183.62	182.76	183.6	1198814.0
2020-02-06 13:00:00	MSFT	Stock	183.6	183.82	183.03	183.129	1252756.0

> showing 50 of 86,713 rows — these rows as CSV

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