PREVIEW / stock_30min / 2008-04-11

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-11.parquet
  size:    1.2 MB
  rows:    68,561
  symbols: 3,293

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-04-11 04:30:00	AAPL	Stock	5.5789	5.5789	5.5789	5.5789	5600.0
2008-04-11 05:00:00	AAPL	Stock	5.5871	5.5871	5.5871	5.5871	2800.0
2008-04-11 06:30:00	AAPL	Stock	5.5411	5.5411	5.4979	5.4979	85148.0
2008-04-11 07:00:00	AAPL	Stock	5.4857	5.495	5.4732	5.4732	258160.0
2008-04-11 07:30:00	AAPL	Stock	5.4679	5.4871	5.4643	5.475	192920.0
2008-04-11 08:00:00	AAPL	Stock	5.4732	5.4857	5.4507	5.4557	2510816.0
2008-04-11 08:30:00	AAPL	Stock	5.4554	5.4646	5.4507	5.455	2154572.0
2008-04-11 09:00:00	AAPL	Stock	5.455	5.4568	5.4429	5.4536	2684136.0
2008-04-11 09:30:00	AAPL	Stock	5.4536	5.475	5.4418	5.4461	132361852.0
2008-04-11 10:00:00	AAPL	Stock	5.4475	5.4568	5.415	5.4507	99120644.0
2008-04-11 10:30:00	AAPL	Stock	5.4511	5.455	5.4239	5.4293	64458548.0
2008-04-11 11:00:00	AAPL	Stock	5.4289	5.4386	5.4121	5.4132	47792528.0
2008-04-11 11:30:00	AAPL	Stock	5.4132	5.4375	5.4086	5.4275	41791288.0
2008-04-11 12:00:00	AAPL	Stock	5.4279	5.4286	5.3829	5.3911	58767828.0
2008-04-11 12:30:00	AAPL	Stock	5.3907	5.4025	5.3804	5.3904	50718164.0
2008-04-11 13:00:00	AAPL	Stock	5.3897	5.3911	5.3464	5.3504	61628336.0
2008-04-11 13:30:00	AAPL	Stock	5.35	5.3505	5.2764	5.3014	139529348.0
2008-04-11 14:00:00	AAPL	Stock	5.3007	5.3071	5.2564	5.2857	112366800.0
2008-04-11 14:30:00	AAPL	Stock	5.2857	5.2979	5.2507	5.2693	103874652.0
2008-04-11 15:00:00	AAPL	Stock	5.2696	5.2764	5.2414	5.2686	112422072.0
2008-04-11 15:30:00	AAPL	Stock	5.2689	5.2689	5.2286	5.2579	147734804.0
2008-04-11 16:00:00	AAPL	Stock	5.2584	5.3475	5.25	5.2589	13722156.0
2008-04-11 16:30:00	AAPL	Stock	5.2561	5.2607	5.255	5.2586	695324.0
2008-04-11 17:00:00	AAPL	Stock	5.2586	5.2963	5.2543	5.2589	481460.0
2008-04-11 17:30:00	AAPL	Stock	5.2604	5.2625	5.2568	5.2568	287336.0
2008-04-11 18:00:00	AAPL	Stock	5.2571	5.2571	5.2539	5.2539	4370324.0
2008-04-11 18:30:00	AAPL	Stock	5.2539	5.2539	5.2479	5.25	394212.0
2008-04-11 19:00:00	AAPL	Stock	5.25	5.2504	5.2357	5.2375	640780.0
2008-04-11 19:30:00	AAPL	Stock	5.2357	5.2446	5.235	5.2439	586292.0
2008-04-11 06:30:00	MSFT	Stock	29.14	29.14	29.03	29.03	620.0
2008-04-11 07:00:00	MSFT	Stock	29.0	29.0	28.98	28.98	800.0
2008-04-11 07:30:00	MSFT	Stock	28.95	28.95	28.95	28.95	3000.0
2008-04-11 08:00:00	MSFT	Stock	28.95	29.0	28.82	28.85	36660.0
2008-04-11 08:30:00	MSFT	Stock	28.85	28.88	28.83	28.88	16086.0
2008-04-11 09:00:00	MSFT	Stock	28.85	28.87	28.8	28.87	28148.0
2008-04-11 09:30:00	MSFT	Stock	28.87	29.01	28.65	28.7	4934321.0
2008-04-11 10:00:00	MSFT	Stock	28.71	28.73	28.58	28.65	4659646.0
2008-04-11 10:30:00	MSFT	Stock	28.65	28.71	28.55	28.59	4377936.0
2008-04-11 11:00:00	MSFT	Stock	28.6	28.69	28.55	28.58	3719192.0
2008-04-11 11:30:00	MSFT	Stock	28.59	28.69	28.57	28.65	1970655.0
2008-04-11 12:00:00	MSFT	Stock	28.65	28.66	28.5	28.52	3138079.0
2008-04-11 12:30:00	MSFT	Stock	28.52	28.58	28.48	28.529	2263628.0
2008-04-11 13:00:00	MSFT	Stock	28.52	28.61	28.51	28.53	1453706.0
2008-04-11 13:30:00	MSFT	Stock	28.53	28.53	28.44	28.49	1980521.0
2008-04-11 14:00:00	MSFT	Stock	28.48	28.51	28.38	28.39	2299045.0
2008-04-11 14:30:00	MSFT	Stock	28.39	28.43	28.34	28.36	3133527.0
2008-04-11 15:00:00	MSFT	Stock	28.37	28.4	28.289	28.36	2719728.0
2008-04-11 15:30:00	MSFT	Stock	28.36	28.65	28.21	28.32	7930437.0
2008-04-11 16:00:00	MSFT	Stock	28.28	28.525	28.263	28.35	3161564.0
2008-04-11 16:30:00	MSFT	Stock	28.37	28.39	28.28	28.36	145122.0

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

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