PREVIEW / stock_30min / 2005-04-20

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-04-20.parquet
  size:    843 KB
  rows:    45,109
  symbols: 1,962

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
2005-04-20 08:00:00	AAPL	Stock	1.35	1.3554	1.3393	1.3489	1859648.0
2005-04-20 08:30:00	AAPL	Stock	1.3486	1.3507	1.3364	1.3496	3096324.0
2005-04-20 09:00:00	AAPL	Stock	1.35	1.35	1.3357	1.3457	6117972.0
2005-04-20 09:30:00	AAPL	Stock	1.345	1.3479	1.3168	1.3196	140660492.0
2005-04-20 10:00:00	AAPL	Stock	1.3193	1.3286	1.3086	1.3278	121011744.0
2005-04-20 10:30:00	AAPL	Stock	1.3282	1.3282	1.3132	1.3204	78835876.0
2005-04-20 11:00:00	AAPL	Stock	1.3204	1.3261	1.3136	1.3203	55866524.0
2005-04-20 11:30:00	AAPL	Stock	1.3204	1.3271	1.3182	1.3261	26546352.0
2005-04-20 12:00:00	AAPL	Stock	1.3264	1.3286	1.3175	1.3182	33824056.0
2005-04-20 12:30:00	AAPL	Stock	1.3186	1.3221	1.3004	1.3018	53349016.0
2005-04-20 13:00:00	AAPL	Stock	1.3025	1.3214	1.2954	1.2957	47376504.0
2005-04-20 13:30:00	AAPL	Stock	1.2954	1.2971	1.2893	1.2929	56191884.0
2005-04-20 14:00:00	AAPL	Stock	1.2932	1.2939	1.2761	1.2796	75636064.0
2005-04-20 14:30:00	AAPL	Stock	1.2793	1.2875	1.2732	1.2871	59528924.0
2005-04-20 15:00:00	AAPL	Stock	1.2871	1.2907	1.2743	1.2775	66490956.0
2005-04-20 15:30:00	AAPL	Stock	1.2771	1.2793	1.2657	1.27	98478100.0
2005-04-20 16:00:00	AAPL	Stock	1.2679	1.2786	1.2654	1.2696	2225468.0
2005-04-20 16:30:00	AAPL	Stock	1.2696	1.2721	1.2682	1.2714	7919100.0
2005-04-20 17:00:00	AAPL	Stock	1.2721	1.3041	1.2679	1.2714	9178512.0
2005-04-20 17:30:00	AAPL	Stock	1.2714	1.3036	1.2679	1.2721	595588.0
2005-04-20 18:00:00	AAPL	Stock	1.2721	1.2743	1.2721	1.2736	171528.0
2005-04-20 08:00:00	MSFT	Stock	24.76	24.85	24.76	24.8	61728.0
2005-04-20 08:30:00	MSFT	Stock	24.81	24.83	24.75	24.79	48453.0
2005-04-20 09:00:00	MSFT	Stock	24.78	24.85	24.64	24.65	257783.0
2005-04-20 09:30:00	MSFT	Stock	24.66	24.7	24.53	24.56	8957093.0
2005-04-20 10:00:00	MSFT	Stock	24.57	24.69	24.56	24.64	7308468.0
2005-04-20 10:30:00	MSFT	Stock	24.65	24.66	24.5	24.61	6830933.0
2005-04-20 11:00:00	MSFT	Stock	24.6	24.64	24.53	24.57	5070814.0
2005-04-20 11:30:00	MSFT	Stock	24.56	24.61	24.54	24.61	2273837.0
2005-04-20 12:00:00	MSFT	Stock	24.61	24.65	24.55	24.58	2581701.0
2005-04-20 12:30:00	MSFT	Stock	24.581	24.6	24.46	24.47	3492756.0
2005-04-20 13:00:00	MSFT	Stock	24.47	24.5	24.42	24.44	3282833.0
2005-04-20 13:30:00	MSFT	Stock	24.44	24.49	24.4	24.45	5395657.0
2005-04-20 14:00:00	MSFT	Stock	24.45	24.48	24.4	24.411	6579667.0
2005-04-20 14:30:00	MSFT	Stock	24.41	24.48	24.37	24.48	6005294.0
2005-04-20 15:00:00	MSFT	Stock	24.48	24.5	24.36	24.38	6210400.0
2005-04-20 15:30:00	MSFT	Stock	24.39	24.41	24.3	24.33	10279488.0
2005-04-20 16:00:00	MSFT	Stock	24.33	24.38	24.29	24.34	275670.0
2005-04-20 16:30:00	MSFT	Stock	24.32	24.409	24.3	24.36	15423424.0
2005-04-20 17:00:00	MSFT	Stock	24.34	24.485	24.31	24.34	208147.0
2005-04-20 17:30:00	MSFT	Stock	24.35	24.518	24.35	24.518	54189.0
2005-04-20 18:00:00	MSFT	Stock	24.33	24.33	24.32	24.32	3170.0
2005-04-20 08:00:00	NVDA	Stock	0.1858	0.1862	0.1858	0.1862	24000.0
2005-04-20 08:30:00	NVDA	Stock	0.1862	0.1877	0.1858	0.1875	324000.0
2005-04-20 09:00:00	NVDA	Stock	0.1867	0.187	0.186	0.1862	564000.0
2005-04-20 09:30:00	NVDA	Stock	0.1859	0.1871	0.1835	0.1835	61837200.0
2005-04-20 10:00:00	NVDA	Stock	0.1835	0.1837	0.1827	0.1835	49387920.0
2005-04-20 10:30:00	NVDA	Stock	0.1837	0.1837	0.1817	0.1828	34582560.0
2005-04-20 11:00:00	NVDA	Stock	0.1827	0.1832	0.1821	0.1827	33928920.0
2005-04-20 11:30:00	NVDA	Stock	0.1827	0.1827	0.1817	0.1825	24270360.0

> showing 50 of 45,109 rows — these rows as CSV

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