PREVIEW / stock_30min / 2021-01-26

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-26.parquet
  size:    2.3 MB
  rows:    117,377
  symbols: 2,723

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
2021-01-26 04:00:00	AAPL	Stock	142.91	143.28	142.8	143.19	26316.0
2021-01-26 04:30:00	AAPL	Stock	143.2	143.2	142.68	142.68	11997.0
2021-01-26 05:00:00	AAPL	Stock	142.78	143.1	142.78	142.85	12887.0
2021-01-26 05:30:00	AAPL	Stock	142.94	143.12	142.9	143.12	9373.0
2021-01-26 06:00:00	AAPL	Stock	143.13	143.3	143.0	143.21	15696.0
2021-01-26 06:30:00	AAPL	Stock	143.23	143.5	143.01	143.23	32566.0
2021-01-26 07:00:00	AAPL	Stock	143.25	143.77	143.15	143.64	263010.0
2021-01-26 07:30:00	AAPL	Stock	143.65	143.65	143.26	143.26	171955.0
2021-01-26 08:00:00	AAPL	Stock	142.92	143.77	142.57	143.2	387645.0
2021-01-26 08:30:00	AAPL	Stock	143.23	143.4	143.02	143.18	267468.0
2021-01-26 09:00:00	AAPL	Stock	143.19	143.72	143.17	143.54	468184.0
2021-01-26 09:30:00	AAPL	Stock	143.58	144.3	141.37	143.05	17396928.0
2021-01-26 10:00:00	AAPL	Stock	143.04	143.22	141.89	142.212	7705911.0
2021-01-26 10:30:00	AAPL	Stock	142.222	142.7	141.92	142.7	6519260.0
2021-01-26 11:00:00	AAPL	Stock	142.69	143.18	142.24	142.33	6320494.0
2021-01-26 11:30:00	AAPL	Stock	142.31	142.44	141.83	141.92	4187823.0
2021-01-26 12:00:00	AAPL	Stock	141.93	142.45	141.91	142.405	4470807.0
2021-01-26 12:30:00	AAPL	Stock	142.4	142.405	141.93	142.2	2883851.0
2021-01-26 13:00:00	AAPL	Stock	142.211	142.66	142.04	142.5	2882620.0
2021-01-26 13:30:00	AAPL	Stock	142.5	143.2	142.495	142.962	4212053.0
2021-01-26 14:00:00	AAPL	Stock	142.965	143.37	142.78	142.96	4317265.0
2021-01-26 14:30:00	AAPL	Stock	142.97	143.12	142.63	142.91	3479260.0
2021-01-26 15:00:00	AAPL	Stock	142.92	143.13	142.76	143.08	3330767.0
2021-01-26 15:30:00	AAPL	Stock	143.09	143.32	142.84	143.185	7476057.0
2021-01-26 16:00:00	AAPL	Stock	143.18	145.0	143.16	144.23	5835550.0
2021-01-26 16:30:00	AAPL	Stock	144.25	144.5	143.93	144.27	386585.0
2021-01-26 17:00:00	AAPL	Stock	144.25	144.54	144.19	144.5	214430.0
2021-01-26 17:30:00	AAPL	Stock	144.5	144.95	144.41	144.92	278591.0
2021-01-26 18:00:00	AAPL	Stock	144.88	145.0	144.62	144.93	214723.0
2021-01-26 18:30:00	AAPL	Stock	144.92	144.99	144.77	144.9	146906.0
2021-01-26 19:00:00	AAPL	Stock	144.91	144.95	144.76	144.92	142485.0
2021-01-26 19:30:00	AAPL	Stock	144.95	145.07	144.87	145.02	269788.0
2021-01-26 04:00:00	MSFT	Stock	229.01	229.49	229.01	229.49	994.0
2021-01-26 04:30:00	MSFT	Stock	229.3	229.3	229.0	229.2	2249.0
2021-01-26 05:00:00	MSFT	Stock	229.44	229.44	229.44	229.44	100.0
2021-01-26 05:30:00	MSFT	Stock	229.53	229.88	229.53	229.7	786.0
2021-01-26 06:00:00	MSFT	Stock	229.8	229.93	229.75	229.75	2108.0
2021-01-26 06:30:00	MSFT	Stock	230.1	230.75	229.99	230.3	25338.0
2021-01-26 07:00:00	MSFT	Stock	230.2	231.23	230.03	230.9	69809.0
2021-01-26 07:30:00	MSFT	Stock	230.9	231.45	230.75	231.15	73529.0
2021-01-26 08:00:00	MSFT	Stock	229.53	231.85	228.96	231.79	140162.0
2021-01-26 08:30:00	MSFT	Stock	231.85	233.0	231.76	231.92	99702.0
2021-01-26 09:00:00	MSFT	Stock	232.04	232.3	231.77	231.77	86057.0
2021-01-26 09:30:00	MSFT	Stock	231.77	232.99	230.08	231.975	4752928.0
2021-01-26 10:00:00	MSFT	Stock	232.0	233.36	230.89	233.095	3058676.0
2021-01-26 10:30:00	MSFT	Stock	233.09	234.18	232.39	233.583	3000140.0
2021-01-26 11:00:00	MSFT	Stock	233.665	233.86	231.45	231.568	2276162.0
2021-01-26 11:30:00	MSFT	Stock	231.56	232.0	231.23	231.41	1224457.0
2021-01-26 12:00:00	MSFT	Stock	231.402	232.98	231.402	232.61	1863962.0
2021-01-26 12:30:00	MSFT	Stock	232.61	232.62	231.9	232.046	962809.0

> showing 50 of 117,377 rows — these rows as CSV

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