PREVIEW / stock_30min / 2007-01-08

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-08.parquet
  size:    976 KB
  rows:    52,510
  symbols: 2,483

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-08 05:30:00	AAPL	Stock	3.0421	3.0443	3.0421	3.0443	11200.0
2007-01-08 06:00:00	AAPL	Stock	3.0429	3.0429	3.0429	3.0429	33600.0
2007-01-08 06:30:00	AAPL	Stock	3.0582	3.0714	3.0582	3.0686	55720.0
2007-01-08 07:00:00	AAPL	Stock	3.0554	3.0736	3.055	3.0736	330400.0
2007-01-08 07:30:00	AAPL	Stock	3.0743	3.0779	3.07	3.075	463120.0
2007-01-08 08:00:00	AAPL	Stock	3.0739	3.0764	3.0489	3.0518	3574676.0
2007-01-08 08:30:00	AAPL	Stock	3.0518	3.0604	3.05	3.0571	827596.0
2007-01-08 09:00:00	AAPL	Stock	3.0589	3.0721	3.0554	3.0693	2329320.0
2007-01-08 09:30:00	AAPL	Stock	3.07	3.0904	3.0504	3.075	159106276.0
2007-01-08 10:00:00	AAPL	Stock	3.0746	3.0864	3.0625	3.0668	82342652.0
2007-01-08 10:30:00	AAPL	Stock	3.0664	3.0768	3.0568	3.0568	72589860.0
2007-01-08 11:00:00	AAPL	Stock	3.0568	3.0743	3.0561	3.0636	47823860.0
2007-01-08 11:30:00	AAPL	Stock	3.0636	3.0746	3.0607	3.0714	46038244.0
2007-01-08 12:00:00	AAPL	Stock	3.0714	3.075	3.0636	3.0654	40006176.0
2007-01-08 12:30:00	AAPL	Stock	3.0657	3.0704	3.0625	3.0667	26872272.0
2007-01-08 13:00:00	AAPL	Stock	3.0667	3.0707	3.0607	3.0696	25072376.0
2007-01-08 13:30:00	AAPL	Stock	3.0696	3.0846	3.0693	3.0789	54821452.0
2007-01-08 14:00:00	AAPL	Stock	3.0789	3.0804	3.0682	3.0689	43196468.0
2007-01-08 14:30:00	AAPL	Stock	3.0689	3.075	3.0507	3.0557	59671780.0
2007-01-08 15:00:00	AAPL	Stock	3.0561	3.0628	3.0554	3.0575	48453412.0
2007-01-08 15:30:00	AAPL	Stock	3.0575	3.0614	3.0457	3.0521	73941392.0
2007-01-08 16:00:00	AAPL	Stock	3.0525	3.0596	3.05	3.0571	1676584.0
2007-01-08 16:30:00	AAPL	Stock	3.0571	3.0586	3.0557	3.0571	181552.0
2007-01-08 17:00:00	AAPL	Stock	3.0575	3.06	3.0561	3.0571	292124.0
2007-01-08 17:30:00	AAPL	Stock	3.0571	3.0589	3.0539	3.0543	392196.0
2007-01-08 18:00:00	AAPL	Stock	3.0564	3.0579	3.0561	3.0579	106064.0
2007-01-08 18:30:00	AAPL	Stock	3.0718	3.0718	3.0536	3.0554	280252.0
2007-01-08 19:00:00	AAPL	Stock	3.0539	3.0589	3.0539	3.0539	172284.0
2007-01-08 19:30:00	AAPL	Stock	3.0582	3.0589	3.0557	3.0586	54180.0
2007-01-08 06:30:00	MSFT	Stock	29.62	29.62	29.62	29.62	500.0
2007-01-08 08:00:00	MSFT	Stock	29.6	29.66	29.6	29.63	11195.0
2007-01-08 08:30:00	MSFT	Stock	29.64	29.67	29.64	29.65	21100.0
2007-01-08 09:00:00	MSFT	Stock	29.67	29.72	29.64	29.65	209640.0
2007-01-08 09:30:00	MSFT	Stock	29.65	29.81	29.65	29.68	5442750.0
2007-01-08 10:00:00	MSFT	Stock	29.69	29.74	29.53	29.55	4163245.0
2007-01-08 10:30:00	MSFT	Stock	29.56	29.76	29.56	29.72	3694824.0
2007-01-08 11:00:00	MSFT	Stock	29.72	29.82	29.69	29.73	3038467.0
2007-01-08 11:30:00	MSFT	Stock	29.73	29.8	29.67	29.8	2347408.0
2007-01-08 12:00:00	MSFT	Stock	29.79	29.88	29.78	29.8	2151362.0
2007-01-08 12:30:00	MSFT	Stock	29.81	29.85	29.78	29.81	1921662.0
2007-01-08 13:00:00	MSFT	Stock	29.81	29.85	29.77	29.84	1417566.0
2007-01-08 13:30:00	MSFT	Stock	29.83	29.91	29.8	29.89	2653456.0
2007-01-08 14:00:00	MSFT	Stock	29.893	29.98	29.86	29.96	3311686.0
2007-01-08 14:30:00	MSFT	Stock	29.97	30.0	29.91	29.95	3242248.0
2007-01-08 15:00:00	MSFT	Stock	29.95	30.1	29.94	30.0	6029929.0
2007-01-08 15:30:00	MSFT	Stock	30.0	30.03	29.674	29.94	6256980.0
2007-01-08 16:00:00	MSFT	Stock	29.94	29.96	29.93	29.93	45397.0
2007-01-08 16:30:00	MSFT	Stock	29.93	29.93	29.92	29.93	1798902.0
2007-01-08 17:00:00	MSFT	Stock	29.94	29.94	29.93	29.93	1400.0
2007-01-08 18:30:00	MSFT	Stock	29.93	29.93	29.93	29.93	200.0

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

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