PREVIEW / stock_30min / 2007-01-22

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-22.parquet
  size:    968 KB
  rows:    52,644
  symbols: 2,501

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-01-22 06:00:00	AAPL	Stock	3.1686	3.1686	3.1654	3.1654	22400.0
2007-01-22 06:30:00	AAPL	Stock	3.1714	3.1714	3.1714	3.1714	2800.0
2007-01-22 07:30:00	AAPL	Stock	3.175	3.1861	3.1739	3.1832	469616.0
2007-01-22 08:00:00	AAPL	Stock	3.1821	3.1821	3.1679	3.1696	1337112.0
2007-01-22 08:30:00	AAPL	Stock	3.1714	3.175	3.1682	3.1732	910420.0
2007-01-22 09:00:00	AAPL	Stock	3.1743	3.1836	3.17	3.1829	3203956.0
2007-01-22 09:30:00	AAPL	Stock	3.1836	3.1843	3.1314	3.14	152458348.0
2007-01-22 10:00:00	AAPL	Stock	3.1404	3.1429	3.0711	3.0904	278525296.0
2007-01-22 10:30:00	AAPL	Stock	3.09	3.1386	3.0607	3.0682	179412268.0
2007-01-22 11:00:00	AAPL	Stock	3.0686	3.0964	3.0589	3.0675	116093572.0
2007-01-22 11:30:00	AAPL	Stock	3.0675	3.0964	3.0607	3.0746	95262244.0
2007-01-22 12:00:00	AAPL	Stock	3.0746	3.0914	3.0682	3.0882	70137004.0
2007-01-22 12:30:00	AAPL	Stock	3.0882	3.0914	3.0732	3.0779	71545824.0
2007-01-22 13:00:00	AAPL	Stock	3.0779	3.0914	3.0725	3.0854	43800988.0
2007-01-22 13:30:00	AAPL	Stock	3.0854	3.0857	3.0746	3.0821	39745356.0
2007-01-22 14:00:00	AAPL	Stock	3.0821	3.1061	3.0786	3.1046	91962024.0
2007-01-22 14:30:00	AAPL	Stock	3.1047	3.1161	3.1011	3.1154	115246796.0
2007-01-22 15:00:00	AAPL	Stock	3.1154	3.1157	3.0964	3.1061	77474236.0
2007-01-22 15:30:00	AAPL	Stock	3.1057	3.1111	3.0989	3.0989	85666784.0
2007-01-22 16:00:00	AAPL	Stock	3.0989	3.1036	3.0925	3.0957	4633608.0
2007-01-22 16:30:00	AAPL	Stock	3.0975	3.1018	3.0921	3.1	742196.0
2007-01-22 17:00:00	AAPL	Stock	3.0996	3.1007	3.0979	3.0982	3411884.0
2007-01-22 17:30:00	AAPL	Stock	3.0964	3.1	3.0964	3.1	170912.0
2007-01-22 18:00:00	AAPL	Stock	3.0982	3.1007	3.0982	3.1	130648.0
2007-01-22 18:30:00	AAPL	Stock	3.0996	3.0996	3.0929	3.0961	130564.0
2007-01-22 19:00:00	AAPL	Stock	3.0946	3.0964	3.0929	3.0961	102312.0
2007-01-22 19:30:00	AAPL	Stock	3.0946	3.0961	3.0936	3.0936	200116.0
2007-01-22 08:00:00	MSFT	Stock	31.13	31.17	31.13	31.15	600.0
2007-01-22 08:30:00	MSFT	Stock	31.15	31.18	31.11	31.11	3247.0
2007-01-22 09:00:00	MSFT	Stock	31.11	31.11	31.02	31.07	172181.0
2007-01-22 09:30:00	MSFT	Stock	31.06	31.12	30.85	30.92	5412952.0
2007-01-22 10:00:00	MSFT	Stock	30.91	30.92	30.7	30.81	6016814.0
2007-01-22 10:30:00	MSFT	Stock	30.81	30.82	30.63	30.64	5377805.0
2007-01-22 11:00:00	MSFT	Stock	30.64	30.68	30.55	30.56	4282488.0
2007-01-22 11:30:00	MSFT	Stock	30.57	30.61	30.51	30.54	3346856.0
2007-01-22 12:00:00	MSFT	Stock	30.54	30.59	30.53	30.57	2777018.0
2007-01-22 12:30:00	MSFT	Stock	30.58	30.64	30.54	30.6	1999213.0
2007-01-22 13:00:00	MSFT	Stock	30.6	30.68	30.52	30.62	3015711.0
2007-01-22 13:30:00	MSFT	Stock	30.63	30.637	30.54	30.63	1725341.0
2007-01-22 14:00:00	MSFT	Stock	30.63	30.64	30.57	30.61	2260263.0
2007-01-22 14:30:00	MSFT	Stock	30.6	30.69	30.58	30.68	2994973.0
2007-01-22 15:00:00	MSFT	Stock	30.68	30.68	30.54	30.59	3102268.0
2007-01-22 15:30:00	MSFT	Stock	30.59	30.73	30.57	30.73	6293127.0
2007-01-22 16:00:00	MSFT	Stock	30.73	30.73	30.7	30.73	1182171.0
2007-01-22 16:30:00	MSFT	Stock	30.73	30.77	30.72	30.73	265756.0
2007-01-22 17:00:00	MSFT	Stock	30.73	30.74	30.64	30.71	5854.0
2007-01-22 17:30:00	MSFT	Stock	30.73	30.73	30.71	30.71	1004210.0
2007-01-22 18:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	1000.0
2007-01-22 18:30:00	MSFT	Stock	30.68	30.68	30.67	30.68	7200.0
2007-01-22 07:00:00	NVDA	Stock	0.5325	0.5325	0.5325	0.5325	6000.0

> showing 50 of 52,644 rows — these rows as CSV

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