PREVIEW / etf_30min / 2008-08-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-08.parquet
  size:    173 KB
  rows:    6,028

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-08-08 04:00:00	SPY	ETF	127.31	127.31	127.3	127.3	1000.0
2008-08-08 04:30:00	SPY	ETF	127.45	127.52	127.45	127.52	600.0
2008-08-08 05:00:00	SPY	ETF	127.31	127.31	127.31	127.31	100.0
2008-08-08 06:00:00	SPY	ETF	127.45	127.45	127.3	127.36	106000.0
2008-08-08 06:30:00	SPY	ETF	127.43	127.54	127.25	127.45	127100.0
2008-08-08 07:00:00	SPY	ETF	127.42	127.5	127.38	127.5	191307.0
2008-08-08 07:30:00	SPY	ETF	127.48	127.48	126.8	126.9	960422.0
2008-08-08 08:00:00	SPY	ETF	126.92	127.36	126.7	126.9	2156256.0
2008-08-08 08:30:00	SPY	ETF	126.85	127.09	126.81	126.9	1682975.0
2008-08-08 09:00:00	SPY	ETF	126.88	127.45	126.51	126.6	3597241.0
2008-08-08 09:30:00	SPY	ETF	126.58	127.48	126.38	127.36	42203110.0
2008-08-08 10:00:00	SPY	ETF	127.36	128.82	127.27	128.64	45747512.0
2008-08-08 10:30:00	SPY	ETF	128.64	128.68	128.36	128.5	16860564.0
2008-08-08 11:00:00	SPY	ETF	128.5	128.65	128.32	128.41	13545672.0
2008-08-08 11:30:00	SPY	ETF	128.41	128.69	128.36	128.53	12356946.0
2008-08-08 12:00:00	SPY	ETF	128.53	129.11	128.47	129.02	12663629.0
2008-08-08 12:30:00	SPY	ETF	129.02	129.08	128.885	128.94	6980194.0
2008-08-08 13:00:00	SPY	ETF	128.94	129.34	128.891	129.29	12028537.0
2008-08-08 13:30:00	SPY	ETF	129.29	129.65	129.23	129.38	14056735.0
2008-08-08 14:00:00	SPY	ETF	129.38	129.69	129.32	129.67	9455449.0
2008-08-08 14:30:00	SPY	ETF	129.66	129.82	129.52	129.59	13319561.0
2008-08-08 15:00:00	SPY	ETF	129.6	129.77	129.43	129.59	11601523.0
2008-08-08 15:30:00	SPY	ETF	129.599	129.93	127.2	129.62	27010891.0
2008-08-08 16:00:00	SPY	ETF	129.59	129.7217	129.4	129.49	6501004.0
2008-08-08 16:30:00	SPY	ETF	129.46	129.53	129.46	129.46	4127682.0
2008-08-08 17:00:00	SPY	ETF	129.46	129.5	129.32	129.48	224885.0
2008-08-08 17:30:00	SPY	ETF	129.43	129.55	129.4	129.5	23681.0
2008-08-08 18:00:00	SPY	ETF	129.51	129.51	129.42	129.42	1869.0
2008-08-08 18:30:00	SPY	ETF	129.49	129.49	129.37	129.41	32094.0
2008-08-08 19:00:00	SPY	ETF	129.38	129.39	129.3	129.34	30073.0
2008-08-08 19:30:00	SPY	ETF	129.35	129.35	129.28	129.33	9617.0
2008-08-08 04:30:00	QQQ	ETF	46.53	46.53	46.44	46.44	500.0
2008-08-08 07:00:00	QQQ	ETF	46.5	46.5	46.44	46.49	232300.0
2008-08-08 07:30:00	QQQ	ETF	46.49	46.49	46.31	46.34	322612.0
2008-08-08 08:00:00	QQQ	ETF	46.34	46.48	46.31	46.32	1657578.0
2008-08-08 08:30:00	QQQ	ETF	46.32	46.42	46.3	46.38	987259.0
2008-08-08 09:00:00	QQQ	ETF	46.38	46.41	46.19	46.26	4051526.0
2008-08-08 09:30:00	QQQ	ETF	46.25	46.73	46.15	46.6599	23261738.0
2008-08-08 10:00:00	QQQ	ETF	46.65	47.06	46.64	46.99	20804406.0
2008-08-08 10:30:00	QQQ	ETF	46.99	47.0	46.76	46.84	9606358.0
2008-08-08 11:00:00	QQQ	ETF	46.84	46.99	46.79	46.92	5663974.0
2008-08-08 11:30:00	QQQ	ETF	46.93	47.06	46.89	47.02	5901031.0
2008-08-08 12:00:00	QQQ	ETF	47.0219	47.21	46.97	47.14	6961676.0
2008-08-08 12:30:00	QQQ	ETF	47.13	47.2	47.08	47.13	4407673.0
2008-08-08 13:00:00	QQQ	ETF	47.13	47.26	47.1	47.25	7264972.0
2008-08-08 13:30:00	QQQ	ETF	47.2401	47.35	47.21	47.21	8237556.0
2008-08-08 14:00:00	QQQ	ETF	47.21	47.39	47.18	47.37	9697033.0
2008-08-08 14:30:00	QQQ	ETF	47.37	47.41	47.29	47.33	7336151.0
2008-08-08 15:00:00	QQQ	ETF	47.33	47.38	47.2	47.28	7920830.0
2008-08-08 15:30:00	QQQ	ETF	47.275	47.44	47.24	47.32	12989695.0

> showing 50 of 6,028 rows — these rows as CSV

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