PREVIEW / etf_30min / 2007-06-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-25.parquet
  size:    123 KB
  rows:    4,490

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-25 04:30:00	SPY	ETF	150.5	150.5	150.5	150.5	100.0
2007-06-25 05:00:00	SPY	ETF	150.65	150.65	150.65	150.65	300.0
2007-06-25 06:00:00	SPY	ETF	150.74	150.75	150.58	150.58	19600.0
2007-06-25 06:30:00	SPY	ETF	150.59	150.66	150.56	150.66	16000.0
2007-06-25 07:00:00	SPY	ETF	150.69	150.79	150.55	150.55	226300.0
2007-06-25 07:30:00	SPY	ETF	150.55	150.59	150.41	150.45	664900.0
2007-06-25 08:00:00	SPY	ETF	150.43	150.77	150.4	150.53	1223800.0
2007-06-25 08:30:00	SPY	ETF	150.51	150.81	150.41	150.55	3127700.0
2007-06-25 09:00:00	SPY	ETF	150.56	150.56	150.18	150.24	3742157.0
2007-06-25 09:30:00	SPY	ETF	150.24	150.43	149.55	149.97	28752832.0
2007-06-25 10:00:00	SPY	ETF	149.97	150.76	149.96	150.67	24401396.0
2007-06-25 10:30:00	SPY	ETF	150.67	150.96	150.36	150.95	13925497.0
2007-06-25 11:00:00	SPY	ETF	150.95	151.19	150.71	151.07	12746150.0
2007-06-25 11:30:00	SPY	ETF	151.07	151.13	150.73	150.86	6781532.0
2007-06-25 12:00:00	SPY	ETF	150.86	151.25	150.86	151.03	9654824.0
2007-06-25 12:30:00	SPY	ETF	151.03	151.13	150.91	150.93	2967900.0
2007-06-25 13:00:00	SPY	ETF	150.93	151.04	150.8	150.82	6824938.0
2007-06-25 13:30:00	SPY	ETF	150.81	151.05	150.67	150.68	7969526.0
2007-06-25 14:00:00	SPY	ETF	150.68	150.79	150.12	150.15	19055240.0
2007-06-25 14:30:00	SPY	ETF	150.14	150.36	149.12	149.38	35055912.0
2007-06-25 15:00:00	SPY	ETF	149.37	150.415	149.02	149.56	22689681.0
2007-06-25 15:30:00	SPY	ETF	149.55	149.96	149.37	149.61	22359580.0
2007-06-25 16:00:00	SPY	ETF	149.61	149.9	149.54	149.88	2704200.0
2007-06-25 16:30:00	SPY	ETF	149.88	150.54	149.83	149.95	300700.0
2007-06-25 17:00:00	SPY	ETF	149.96	150.09	149.96	150.06	76700.0
2007-06-25 17:30:00	SPY	ETF	150.0	150.06	150.0	150.06	2400.0
2007-06-25 18:00:00	SPY	ETF	150.05	150.05	150.01	150.01	12200.0
2007-06-25 18:30:00	SPY	ETF	150.01	150.02	149.97	150.01	34300.0
2007-06-25 19:00:00	SPY	ETF	149.98	149.98	149.96	149.98	2100.0
2007-06-25 19:30:00	SPY	ETF	149.95	150.0	149.95	149.98	6200.0
2007-06-25 07:00:00	QQQ	ETF	47.38	47.46	47.36	47.36	355600.0
2007-06-25 07:30:00	QQQ	ETF	47.35	47.36	47.3	47.32	298831.0
2007-06-25 08:00:00	QQQ	ETF	47.32	47.45	47.32	47.38	857419.0
2007-06-25 08:30:00	QQQ	ETF	47.38	47.45	47.37	47.42	739439.0
2007-06-25 09:00:00	QQQ	ETF	47.4	47.4	47.26	47.3	1732412.0
2007-06-25 09:30:00	QQQ	ETF	47.31	47.37	47.0	47.16	23132920.0
2007-06-25 10:00:00	QQQ	ETF	47.1685	47.45	47.16	47.41	16400892.0
2007-06-25 10:30:00	QQQ	ETF	47.4	47.5	47.19	47.5	8316473.0
2007-06-25 11:00:00	QQQ	ETF	47.5	47.53	47.45	47.49	5487462.0
2007-06-25 11:30:00	QQQ	ETF	47.496	47.51	47.39	47.44	3820985.0
2007-06-25 12:00:00	QQQ	ETF	47.45	47.58	47.44	47.51	3886582.0
2007-06-25 12:30:00	QQQ	ETF	47.51	47.53	47.43	47.45	2317348.0
2007-06-25 13:00:00	QQQ	ETF	47.44	47.48	47.4	47.402	3237454.0
2007-06-25 13:30:00	QQQ	ETF	47.4	47.48	47.34	47.35	3272308.0
2007-06-25 14:00:00	QQQ	ETF	47.35	47.39	47.18	47.18	8883434.0
2007-06-25 14:30:00	QQQ	ETF	47.18	47.19	46.9	46.98	17279960.0
2007-06-25 15:00:00	QQQ	ETF	46.98	47.04	46.82	47.01	14966317.0
2007-06-25 15:30:00	QQQ	ETF	47.01	47.12	46.9015	47.06	15586189.0
2007-06-25 16:00:00	QQQ	ETF	47.07	47.16	47.06	47.13	2104422.0
2007-06-25 16:30:00	QQQ	ETF	47.13	47.21	47.13	47.18	297767.0

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

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