PREVIEW / stock_30min / 2020-10-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-16.parquet
  size:    1.9 MB
  rows:    96,568
  symbols: 2,498

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-10-16 04:00:00	AAPL	Stock	121.06	121.42	121.0	121.12	35921.0
2020-10-16 04:30:00	AAPL	Stock	121.2	121.5	120.91	121.47	21444.0
2020-10-16 05:00:00	AAPL	Stock	121.4	121.5	120.95	120.95	26085.0
2020-10-16 05:30:00	AAPL	Stock	120.78	121.1	120.73	120.95	12031.0
2020-10-16 06:00:00	AAPL	Stock	121.05	121.4	120.93	121.4	9625.0
2020-10-16 06:30:00	AAPL	Stock	121.31	121.59	120.65	121.13	32249.0
2020-10-16 07:00:00	AAPL	Stock	121.14	121.32	120.82	121.2	184865.0
2020-10-16 07:30:00	AAPL	Stock	121.25	121.54	121.22	121.38	99990.0
2020-10-16 08:00:00	AAPL	Stock	121.09	121.58	120.89	121.55	409309.0
2020-10-16 08:30:00	AAPL	Stock	121.55	122.11	121.55	121.9	416785.0
2020-10-16 09:00:00	AAPL	Stock	121.89	121.99	121.25	121.25	634733.0
2020-10-16 09:30:00	AAPL	Stock	121.25	121.548	120.31	120.85	16740124.0
2020-10-16 10:00:00	AAPL	Stock	120.846	121.27	120.46	121.15	9244560.0
2020-10-16 10:30:00	AAPL	Stock	121.16	121.228	120.311	120.69	6983269.0
2020-10-16 11:00:00	AAPL	Stock	120.692	120.692	119.53	119.89	7500720.0
2020-10-16 11:30:00	AAPL	Stock	119.89	120.05	119.46	119.98	6185814.0
2020-10-16 12:00:00	AAPL	Stock	119.985	120.11	119.61	119.83	4966990.0
2020-10-16 12:30:00	AAPL	Stock	119.83	119.9	119.29	119.827	5813884.0
2020-10-16 13:00:00	AAPL	Stock	119.825	120.3	119.71	120.06	5103280.0
2020-10-16 13:30:00	AAPL	Stock	120.05	120.36	119.93	120.06	3922207.0
2020-10-16 14:00:00	AAPL	Stock	120.06	120.23	119.875	120.165	3685170.0
2020-10-16 14:30:00	AAPL	Stock	120.17	120.5	120.11	120.39	3935126.0
2020-10-16 15:00:00	AAPL	Stock	120.395	120.49	119.71	119.908	6020168.0
2020-10-16 15:30:00	AAPL	Stock	119.9	119.95	118.81	118.96	12265581.0
2020-10-16 16:00:00	AAPL	Stock	119.02	119.16	118.72	118.92	9275630.0
2020-10-16 16:30:00	AAPL	Stock	118.93	119.02	118.81	118.91	230242.0
2020-10-16 17:00:00	AAPL	Stock	118.91	118.98	118.9	118.91	76481.0
2020-10-16 17:30:00	AAPL	Stock	118.92	118.98	118.9	118.94	58259.0
2020-10-16 18:00:00	AAPL	Stock	118.91	118.98	118.91	118.97	51183.0
2020-10-16 18:30:00	AAPL	Stock	118.97	118.98	118.82	118.84	73872.0
2020-10-16 19:00:00	AAPL	Stock	118.83	118.86	118.81	118.83	50522.0
2020-10-16 19:30:00	AAPL	Stock	118.83	118.83	118.7	118.72	115785.0
2020-10-16 04:00:00	MSFT	Stock	219.91	219.91	219.8	219.81	1200.0
2020-10-16 04:30:00	MSFT	Stock	219.92	219.92	219.74	219.79	1360.0
2020-10-16 05:00:00	MSFT	Stock	219.9	219.9	219.15	219.52	2185.0
2020-10-16 05:30:00	MSFT	Stock	219.19	219.5	219.11	219.5	1242.0
2020-10-16 06:00:00	MSFT	Stock	220.0	220.2	220.0	220.2	555.0
2020-10-16 06:30:00	MSFT	Stock	220.04	220.04	219.0	219.01	6372.0
2020-10-16 07:00:00	MSFT	Stock	219.49	219.99	219.0	219.72	16045.0
2020-10-16 07:30:00	MSFT	Stock	219.98	220.6	219.94	220.45	10967.0
2020-10-16 08:00:00	MSFT	Stock	220.39	220.75	219.12	220.7	16492.0
2020-10-16 08:30:00	MSFT	Stock	220.75	220.999	220.57	220.83	20025.0
2020-10-16 09:00:00	MSFT	Stock	220.86	221.47	220.18	220.18	122107.0
2020-10-16 09:30:00	MSFT	Stock	220.15	220.86	219.67	220.36	3166632.0
2020-10-16 10:00:00	MSFT	Stock	220.35	222.29	220.27	221.935	1460789.0
2020-10-16 10:30:00	MSFT	Stock	221.95	222.15	220.68	221.0	959879.0
2020-10-16 11:00:00	MSFT	Stock	221.0	221.08	219.86	220.16	1111528.0
2020-10-16 11:30:00	MSFT	Stock	220.165	220.79	219.93	220.55	722934.0
2020-10-16 12:00:00	MSFT	Stock	220.53	220.83	219.74	220.74	779370.0
2020-10-16 12:30:00	MSFT	Stock	220.73	220.75	219.77	220.54	788682.0

> showing 50 of 96,568 rows — these rows as CSV

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