PREVIEW / stock_30min / 2008-10-08

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-08.parquet
  size:    1.3 MB
  rows:    75,072
  symbols: 3,383

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
2008-10-08 04:00:00	AAPL	Stock	3.1607	3.1607	3.0214	3.0357	81200.0
2008-10-08 04:30:00	AAPL	Stock	3.0464	3.0532	3.0446	3.0532	53480.0
2008-10-08 05:00:00	AAPL	Stock	3.0529	3.0643	3.0529	3.0643	27860.0
2008-10-08 05:30:00	AAPL	Stock	3.0536	3.0536	3.0536	3.0536	2800.0
2008-10-08 06:00:00	AAPL	Stock	3.0	3.0786	3.0	3.0786	53200.0
2008-10-08 06:30:00	AAPL	Stock	3.0786	3.1071	3.0786	3.1	254268.0
2008-10-08 07:00:00	AAPL	Stock	3.1214	3.3071	3.1214	3.2761	1921416.0
2008-10-08 07:30:00	AAPL	Stock	3.2768	3.2982	3.25	3.2814	1096116.0
2008-10-08 08:00:00	AAPL	Stock	3.2775	3.3214	3.2061	3.2143	4894708.0
2008-10-08 08:30:00	AAPL	Stock	3.2121	3.2418	3.0579	3.0982	7041188.0
2008-10-08 09:00:00	AAPL	Stock	3.0957	3.1175	3.0411	3.0714	7341180.0
2008-10-08 09:30:00	AAPL	Stock	3.0714	3.3429	3.06	3.3111	304690596.0
2008-10-08 10:00:00	AAPL	Stock	3.3107	3.375	3.2071	3.2839	251091148.0
2008-10-08 10:30:00	AAPL	Stock	3.282	3.3264	3.2296	3.3175	177401728.0
2008-10-08 11:00:00	AAPL	Stock	3.3171	3.3861	3.2904	3.3507	150933580.0
2008-10-08 11:30:00	AAPL	Stock	3.35	3.3718	3.2339	3.3068	121699004.0
2008-10-08 12:00:00	AAPL	Stock	3.3071	3.3093	3.1696	3.2239	125894888.0
2008-10-08 12:30:00	AAPL	Stock	3.2214	3.2954	3.2018	3.2836	92027460.0
2008-10-08 13:00:00	AAPL	Stock	3.2825	3.3571	3.2779	3.2932	133579768.0
2008-10-08 13:30:00	AAPL	Stock	3.2957	3.4404	3.2886	3.4371	149457000.0
2008-10-08 14:00:00	AAPL	Stock	3.4384	3.4393	3.3618	3.4011	131076036.0
2008-10-08 14:30:00	AAPL	Stock	3.4004	3.4071	3.3225	3.3546	116107880.0
2008-10-08 15:00:00	AAPL	Stock	3.3549	3.4125	3.3143	3.3732	128793056.0
2008-10-08 15:30:00	AAPL	Stock	3.3721	3.3964	3.165	3.2021	235798640.0
2008-10-08 16:00:00	AAPL	Stock	3.1968	3.308	3.1907	3.2982	28685496.0
2008-10-08 16:30:00	AAPL	Stock	3.1993	3.3429	3.1921	3.1929	2202648.0
2008-10-08 17:00:00	AAPL	Stock	3.195	3.2125	3.1936	3.2068	535836.0
2008-10-08 17:30:00	AAPL	Stock	3.2096	3.2139	3.2025	3.2139	154476.0
2008-10-08 18:00:00	AAPL	Stock	3.2107	3.2321	3.2075	3.2321	207900.0
2008-10-08 18:30:00	AAPL	Stock	3.2286	3.2436	3.225	3.2436	623924.0
2008-10-08 19:00:00	AAPL	Stock	3.2457	3.2625	3.2457	3.25	589512.0
2008-10-08 19:30:00	AAPL	Stock	3.2568	3.2568	3.2396	3.25	249984.0
2008-10-08 04:00:00	MSFT	Stock	22.76	22.76	22.52	22.52	200.0
2008-10-08 04:30:00	MSFT	Stock	22.0	22.52	22.0	22.43	4700.0
2008-10-08 05:00:00	MSFT	Stock	22.46	22.46	22.46	22.46	100.0
2008-10-08 05:30:00	MSFT	Stock	22.48	22.48	22.48	22.48	500.0
2008-10-08 06:30:00	MSFT	Stock	22.55	22.9	22.55	22.9	3440.0
2008-10-08 07:00:00	MSFT	Stock	23.2	23.8	23.15	23.2	130589.0
2008-10-08 07:30:00	MSFT	Stock	23.29	23.59	23.2	23.41	74988.0
2008-10-08 08:00:00	MSFT	Stock	23.5	23.7	23.43	23.5	133387.0
2008-10-08 08:30:00	MSFT	Stock	23.5	23.55	20.82	22.86	453861.0
2008-10-08 09:00:00	MSFT	Stock	22.86	23.3	20.8	22.87	277919.0
2008-10-08 09:30:00	MSFT	Stock	22.89	23.86	22.77	23.59	19922759.0
2008-10-08 10:00:00	MSFT	Stock	23.562	23.99	23.23	23.42	17255496.0
2008-10-08 10:30:00	MSFT	Stock	23.41	23.55	22.89	22.94	14367916.0
2008-10-08 11:00:00	MSFT	Stock	22.94	23.34	22.74	23.09	10597309.0
2008-10-08 11:30:00	MSFT	Stock	23.09	23.17	22.71	23.06	10300675.0
2008-10-08 12:00:00	MSFT	Stock	23.05	23.09	22.5	22.752	11016786.0
2008-10-08 12:30:00	MSFT	Stock	22.75	23.2	22.72	23.02	8097522.0
2008-10-08 13:00:00	MSFT	Stock	23.02	23.62	23.01	23.36	11051060.0

> showing 50 of 75,072 rows — these rows as CSV

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