PREVIEW / stock_30min / 2008-02-27

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-27.parquet
  size:    1.2 MB
  rows:    68,151
  symbols: 3,243

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-02-27 04:30:00	AAPL	Stock	4.2464	4.2464	4.2418	4.2429	22400.0
2008-02-27 05:00:00	AAPL	Stock	4.2429	4.2429	4.2429	4.2429	2800.0
2008-02-27 06:30:00	AAPL	Stock	4.25	4.25	4.25	4.25	2800.0
2008-02-27 07:00:00	AAPL	Stock	4.2446	4.2518	4.2446	4.2518	14000.0
2008-02-27 07:30:00	AAPL	Stock	4.25	4.2514	4.2325	4.2325	50596.0
2008-02-27 08:00:00	AAPL	Stock	4.2379	4.2379	4.1964	4.205	1054284.0
2008-02-27 08:30:00	AAPL	Stock	4.2007	4.2164	4.1929	4.2093	1846964.0
2008-02-27 09:00:00	AAPL	Stock	4.2082	4.2268	4.2046	4.2225	1883980.0
2008-02-27 09:30:00	AAPL	Stock	4.2221	4.2993	4.2175	4.2684	207932396.0
2008-02-27 10:00:00	AAPL	Stock	4.2686	4.2961	4.2407	4.265	127699068.0
2008-02-27 10:30:00	AAPL	Stock	4.2652	4.3214	4.2593	4.2854	141723092.0
2008-02-27 11:00:00	AAPL	Stock	4.2854	4.3079	4.2786	4.2911	84831236.0
2008-02-27 11:30:00	AAPL	Stock	4.2914	4.335	4.2825	4.3325	86268868.0
2008-02-27 12:00:00	AAPL	Stock	4.3321	4.3386	4.3036	4.3082	80363304.0
2008-02-27 12:30:00	AAPL	Stock	4.3075	4.3657	4.3021	4.35	93912616.0
2008-02-27 13:00:00	AAPL	Stock	4.35	4.3661	4.3393	4.3589	80570784.0
2008-02-27 13:30:00	AAPL	Stock	4.3582	4.3657	4.3182	4.3368	83104700.0
2008-02-27 14:00:00	AAPL	Stock	4.3364	4.34	4.2961	4.3018	77524496.0
2008-02-27 14:30:00	AAPL	Stock	4.3029	4.3529	4.3025	4.3486	66119900.0
2008-02-27 15:00:00	AAPL	Stock	4.3493	4.3839	4.3329	4.3829	104977040.0
2008-02-27 15:30:00	AAPL	Stock	4.3829	4.3946	4.3721	4.3893	144354000.0
2008-02-27 16:00:00	AAPL	Stock	4.3893	4.4232	4.3164	4.4182	17673544.0
2008-02-27 16:30:00	AAPL	Stock	4.4182	4.5118	4.3914	4.5018	26513732.0
2008-02-27 17:00:00	AAPL	Stock	4.5036	4.5596	4.2911	4.5314	26103924.0
2008-02-27 17:30:00	AAPL	Stock	4.5321	4.5696	4.5275	4.5471	12290432.0
2008-02-27 18:00:00	AAPL	Stock	4.5468	4.5518	4.5304	4.5404	3536624.0
2008-02-27 18:30:00	AAPL	Stock	4.5396	4.5593	4.5357	4.555	2696204.0
2008-02-27 19:00:00	AAPL	Stock	4.5518	4.5529	4.5393	4.5429	1000244.0
2008-02-27 19:30:00	AAPL	Stock	4.5429	4.55	4.5414	4.5464	1083936.0
2008-02-27 06:00:00	MSFT	Stock	28.28	28.28	28.28	28.28	600.0
2008-02-27 07:00:00	MSFT	Stock	28.21	28.28	28.15	28.28	2016.0
2008-02-27 07:30:00	MSFT	Stock	28.3	28.3	28.26	28.26	600.0
2008-02-27 08:00:00	MSFT	Stock	28.21	28.22	28.11	28.18	43578.0
2008-02-27 08:30:00	MSFT	Stock	28.16	28.21	28.16	28.2	24257.0
2008-02-27 09:00:00	MSFT	Stock	28.21	28.21	28.1	28.2	55940.0
2008-02-27 09:30:00	MSFT	Stock	28.19	28.44	28.18	28.43	7094737.0
2008-02-27 10:00:00	MSFT	Stock	28.44	28.44	28.17	28.18	6315709.0
2008-02-27 10:30:00	MSFT	Stock	28.18	28.68	28.18	28.46	7056586.0
2008-02-27 11:00:00	MSFT	Stock	28.45	28.53	28.36	28.45	4008563.0
2008-02-27 11:30:00	MSFT	Stock	28.45	28.53	28.41	28.48	4312814.0
2008-02-27 12:00:00	MSFT	Stock	28.47	28.48	28.32	28.328	4298195.0
2008-02-27 12:30:00	MSFT	Stock	28.33	28.35	28.26	28.305	5640734.0
2008-02-27 13:00:00	MSFT	Stock	28.3	28.33	28.23	28.282	3847897.0
2008-02-27 13:30:00	MSFT	Stock	28.289	28.3	28.17	28.18	3906257.0
2008-02-27 14:00:00	MSFT	Stock	28.19	28.19	28.1	28.13	5679232.0
2008-02-27 14:30:00	MSFT	Stock	28.14	28.29	28.13	28.28	4910830.0
2008-02-27 15:00:00	MSFT	Stock	28.29	28.36	28.22	28.35	6502330.0
2008-02-27 15:30:00	MSFT	Stock	28.36	28.41	28.2	28.3	9320864.0
2008-02-27 16:00:00	MSFT	Stock	28.3	28.54	28.23	28.26	2377639.0
2008-02-27 16:30:00	MSFT	Stock	28.26	28.415	28.26	28.33	36358.0

> showing 50 of 68,151 rows — these rows as CSV

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