PREVIEW / stock_30min / 2007-06-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-20.parquet
  size:    1.1 MB
  rows:    63,402
  symbols: 3,022

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
2007-06-20 09:30:00	AAPL	Stock	4.4239	4.4521	4.3964	4.4021	120087240.0
2007-06-20 10:00:00	AAPL	Stock	4.4021	4.4057	4.3607	4.3764	119147560.0
2007-06-20 10:30:00	AAPL	Stock	4.3764	4.4082	4.375	4.4011	69563004.0
2007-06-20 11:00:00	AAPL	Stock	4.4008	4.4025	4.3714	4.3871	66334660.0
2007-06-20 11:30:00	AAPL	Stock	4.3871	4.3996	4.3807	4.3964	50140412.0
2007-06-20 12:00:00	AAPL	Stock	4.3964	4.4086	4.3839	4.3996	44779000.0
2007-06-20 12:30:00	AAPL	Stock	4.3996	4.41	4.3886	4.3886	28425180.0
2007-06-20 13:00:00	AAPL	Stock	4.3882	4.39	4.3511	4.3711	70959532.0
2007-06-20 13:30:00	AAPL	Stock	4.3714	4.4061	4.3671	4.3889	50237320.0
2007-06-20 14:00:00	AAPL	Stock	4.3889	4.3946	4.3775	4.3846	47746160.0
2007-06-20 14:30:00	AAPL	Stock	4.3846	4.3986	4.3779	4.3886	45509660.0
2007-06-20 15:00:00	AAPL	Stock	4.3886	4.39	4.3664	4.3696	54121984.0
2007-06-20 15:30:00	AAPL	Stock	4.3693	4.3743	4.3393	4.3404	88542216.0
2007-06-20 16:00:00	AAPL	Stock	4.3432	4.3436	4.34	4.3411	7348516.0
2007-06-20 09:30:00	MSFT	Stock	30.44	30.51	30.34	30.34	3971995.0
2007-06-20 10:00:00	MSFT	Stock	30.34	30.35	30.2	30.27	3459064.0
2007-06-20 10:30:00	MSFT	Stock	30.27	30.41	30.27	30.36	2784365.0
2007-06-20 11:00:00	MSFT	Stock	30.36	30.38	30.33	30.33	1721782.0
2007-06-20 11:30:00	MSFT	Stock	30.33	30.34	30.23	30.26	2311063.0
2007-06-20 12:00:00	MSFT	Stock	30.25	30.33	30.2	30.33	2038968.0
2007-06-20 12:30:00	MSFT	Stock	30.322	30.38	30.25	30.27	1510297.0
2007-06-20 13:00:00	MSFT	Stock	30.26	30.27	30.12	30.18	2923864.0
2007-06-20 13:30:00	MSFT	Stock	30.18	30.29	30.16	30.21	1827550.0
2007-06-20 14:00:00	MSFT	Stock	30.21	30.26	30.12	30.15	2296702.0
2007-06-20 14:30:00	MSFT	Stock	30.15	30.24	30.11	30.22	2491019.0
2007-06-20 15:00:00	MSFT	Stock	30.22	30.23	30.06	30.07	3643457.0
2007-06-20 15:30:00	MSFT	Stock	30.07	30.09	29.96	30.05	8608107.0
2007-06-20 16:00:00	MSFT	Stock	30.01	30.01	30.01	30.01	1263855.0
2007-06-20 08:00:00	NVDA	Stock	0.67	0.6728	0.6683	0.6683	315000.0
2007-06-20 08:30:00	NVDA	Stock	0.6712	0.6717	0.6692	0.6692	105000.0
2007-06-20 09:00:00	NVDA	Stock	0.67	0.67	0.6663	0.6663	352500.0
2007-06-20 09:30:00	NVDA	Stock	0.6658	0.6677	0.6598	0.666	93605160.0
2007-06-20 10:00:00	NVDA	Stock	0.666	0.6662	0.6618	0.6648	73140840.0
2007-06-20 10:30:00	NVDA	Stock	0.6647	0.6692	0.6636	0.668	47594340.0
2007-06-20 11:00:00	NVDA	Stock	0.6678	0.67	0.6663	0.668	39436140.0
2007-06-20 11:30:00	NVDA	Stock	0.668	0.6687	0.6665	0.6667	41907000.0
2007-06-20 12:00:00	NVDA	Stock	0.6667	0.6692	0.6656	0.6674	45146100.0
2007-06-20 12:30:00	NVDA	Stock	0.6672	0.6697	0.6667	0.6682	30385440.0
2007-06-20 13:00:00	NVDA	Stock	0.6682	0.6682	0.6633	0.6645	73194600.0
2007-06-20 13:30:00	NVDA	Stock	0.6643	0.6683	0.6642	0.666	44221020.0
2007-06-20 14:00:00	NVDA	Stock	0.666	0.6673	0.6643	0.6643	41437380.0
2007-06-20 14:30:00	NVDA	Stock	0.6643	0.6695	0.6638	0.6688	72138900.0
2007-06-20 15:00:00	NVDA	Stock	0.6688	0.669	0.6657	0.667	71943420.0
2007-06-20 15:30:00	NVDA	Stock	0.6668	0.667	0.6613	0.6645	96230760.0
2007-06-20 16:00:00	NVDA	Stock	0.6643	0.6673	0.6635	0.6642	35832360.0
2007-06-20 16:30:00	NVDA	Stock	0.6642	0.6643	0.6635	0.6635	745860.0
2007-06-20 17:30:00	NVDA	Stock	0.6642	0.6642	0.6602	0.6602	56400.0
2007-06-20 18:00:00	NVDA	Stock	0.666	0.666	0.666	0.666	6000.0
2007-06-20 19:30:00	NVDA	Stock	0.666	0.666	0.665	0.665	42000.0
2007-06-20 08:00:00	AMZN	Stock	3.5135	3.5135	3.5115	3.5135	186500.0

> showing 50 of 63,402 rows — these rows as CSV

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