PREVIEW / etf_30min / 2007-06-29

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-29.parquet
  size:    122 KB
  rows:    4,554

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-29 05:00:00	SPY	ETF	150.35	150.35	150.35	150.35	16900.0
2007-06-29 06:00:00	SPY	ETF	150.2	150.2	150.2	150.2	15000.0
2007-06-29 06:30:00	SPY	ETF	150.03	150.03	149.9	150.03	13700.0
2007-06-29 07:00:00	SPY	ETF	149.93	150.13	149.93	150.1	311000.0
2007-06-29 07:30:00	SPY	ETF	150.15	150.15	150.08	150.08	67100.0
2007-06-29 08:00:00	SPY	ETF	150.12	150.38	150.12	150.26	732700.0
2007-06-29 08:30:00	SPY	ETF	150.3	150.7	150.3	150.7	2529100.0
2007-06-29 09:00:00	SPY	ETF	150.7	150.95	150.69	150.83	2641600.0
2007-06-29 09:30:00	SPY	ETF	150.83	151.47	150.78	151.27	17301190.0
2007-06-29 10:00:00	SPY	ETF	151.26	151.65	151.12	151.29	13762146.0
2007-06-29 10:30:00	SPY	ETF	151.29	151.33	151.13	151.16	5722002.0
2007-06-29 11:00:00	SPY	ETF	151.16	151.2	150.85	151.18	5765094.0
2007-06-29 11:30:00	SPY	ETF	151.18	151.29	150.95	151.0	4953653.0
2007-06-29 12:00:00	SPY	ETF	151.01	151.04	150.52	150.63	10911996.0
2007-06-29 12:30:00	SPY	ETF	150.63	150.879	150.24	150.5	8122504.0
2007-06-29 13:00:00	SPY	ETF	150.5	150.62	150.24	150.52	8841597.0
2007-06-29 13:30:00	SPY	ETF	150.52	150.82	150.38	150.66	8817178.0
2007-06-29 14:00:00	SPY	ETF	150.66	150.71	149.96	150.15	15335325.0
2007-06-29 14:30:00	SPY	ETF	150.15	150.55	149.98	150.3	9207933.0
2007-06-29 15:00:00	SPY	ETF	150.29	150.42	149.15	149.23	25589827.0
2007-06-29 15:30:00	SPY	ETF	149.22	150.28	149.16	150.06	35771956.0
2007-06-29 16:00:00	SPY	ETF	150.25	150.45	149.98	150.26	5441700.0
2007-06-29 16:30:00	SPY	ETF	150.26	150.43	150.12	150.31	475700.0
2007-06-29 17:00:00	SPY	ETF	150.3	150.43	150.1784	150.27	297600.0
2007-06-29 17:30:00	SPY	ETF	150.27	150.35	150.1784	150.33	6345300.0
2007-06-29 18:00:00	SPY	ETF	150.31	150.31	150.28	150.28	1100.0
2007-06-29 18:30:00	SPY	ETF	150.29	150.33	150.29	150.33	600.0
2007-06-29 19:00:00	SPY	ETF	150.32	150.33	150.32	150.33	1500.0
2007-06-29 19:30:00	SPY	ETF	150.33	150.33	150.28	150.28	2600.0
2007-06-29 05:30:00	QQQ	ETF	47.57	47.57	47.57	47.57	20000.0
2007-06-29 06:00:00	QQQ	ETF	47.51	47.51	47.5	47.5	12500.0
2007-06-29 06:30:00	QQQ	ETF	47.47	47.47	47.46	47.47	10800.0
2007-06-29 07:00:00	QQQ	ETF	47.43	47.52	47.41	47.52	85683.0
2007-06-29 07:30:00	QQQ	ETF	47.54	47.54	47.51	47.51	102194.0
2007-06-29 08:00:00	QQQ	ETF	47.54	47.61	47.53	47.57	384536.0
2007-06-29 08:30:00	QQQ	ETF	47.58	47.74	47.58	47.72	1976965.0
2007-06-29 09:00:00	QQQ	ETF	47.72	47.81	47.72	47.78	1836266.0
2007-06-29 09:30:00	QQQ	ETF	47.79	47.8	47.71	47.77	10710983.0
2007-06-29 10:00:00	QQQ	ETF	47.76	47.88	47.76	47.81	8226247.0
2007-06-29 10:30:00	QQQ	ETF	47.81	47.82	47.76	47.78	5977119.0
2007-06-29 11:00:00	QQQ	ETF	47.79	47.81	47.68	47.8075	4414139.0
2007-06-29 11:30:00	QQQ	ETF	47.8	47.84	47.76	47.76	5395300.0
2007-06-29 12:00:00	QQQ	ETF	47.76	47.77	47.6	47.66	11872843.0
2007-06-29 12:30:00	QQQ	ETF	47.65	47.67	47.53	47.62	6656203.0
2007-06-29 13:00:00	QQQ	ETF	47.63	47.68	47.58	47.65	3795752.0
2007-06-29 13:30:00	QQQ	ETF	47.65	47.73	47.62	47.68	4135650.0
2007-06-29 14:00:00	QQQ	ETF	47.69	47.69	47.52	47.57	7036233.0
2007-06-29 14:30:00	QQQ	ETF	47.56	47.64	47.53	47.59	4073584.0
2007-06-29 15:00:00	QQQ	ETF	47.59	47.62	47.21	47.27	21952947.0
2007-06-29 15:30:00	QQQ	ETF	47.27	47.59	47.26	47.56	14274394.0

> showing 50 of 4,554 rows — these rows as CSV

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