PREVIEW / etf_30min / 2007-06-22

all etf 30-min files

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

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-22 04:00:00	SPY	ETF	151.51	151.51	151.51	151.51	6200.0
2007-06-22 06:00:00	SPY	ETF	151.28	151.4	151.25	151.34	59100.0
2007-06-22 06:30:00	SPY	ETF	151.55	151.57	151.55	151.57	6000.0
2007-06-22 07:00:00	SPY	ETF	151.57	151.72	151.52	151.72	272300.0
2007-06-22 07:30:00	SPY	ETF	151.71	151.75	151.27	151.3	653400.0
2007-06-22 08:00:00	SPY	ETF	151.28	151.55	151.26	151.36	1082000.0
2007-06-22 08:30:00	SPY	ETF	151.39	151.58	151.38	151.54	1315500.0
2007-06-22 09:00:00	SPY	ETF	151.54	151.54	151.32	151.5	677700.0
2007-06-22 09:30:00	SPY	ETF	151.52	151.77	151.1	151.47	17286865.0
2007-06-22 10:00:00	SPY	ETF	151.47	151.48	151.05	151.1	14025486.0
2007-06-22 10:30:00	SPY	ETF	151.1	151.41	150.82	151.23	14305368.0
2007-06-22 11:00:00	SPY	ETF	151.23	151.36	151.1	151.25	5293794.0
2007-06-22 11:30:00	SPY	ETF	151.25	151.43	150.96	151.23	9629501.0
2007-06-22 12:00:00	SPY	ETF	151.22	151.35	150.13	150.25	20118795.0
2007-06-22 12:30:00	SPY	ETF	150.25	151.05	149.94	150.41	18812577.0
2007-06-22 13:00:00	SPY	ETF	150.41	150.76	149.95	150.68	21967581.0
2007-06-22 13:30:00	SPY	ETF	150.68	150.8	150.37	150.46	9836290.0
2007-06-22 14:00:00	SPY	ETF	150.47	150.61	150.12	150.59	8993748.0
2007-06-22 14:30:00	SPY	ETF	150.6	151.03	150.32	150.58	10980136.0
2007-06-22 15:00:00	SPY	ETF	150.58	150.66	150.25	150.26	7632275.0
2007-06-22 15:30:00	SPY	ETF	150.26	150.5	149.85	150.24	27099115.0
2007-06-22 16:00:00	SPY	ETF	150.23	150.64	150.063	150.57	9373800.0
2007-06-22 16:30:00	SPY	ETF	150.59	150.64	150.23	150.63	901700.0
2007-06-22 17:00:00	SPY	ETF	150.63	150.75	150.62	150.75	154000.0
2007-06-22 17:30:00	SPY	ETF	150.75	150.85	150.75	150.85	59400.0
2007-06-22 18:00:00	SPY	ETF	150.85	150.85	150.65	150.65	24200.0
2007-06-22 18:30:00	SPY	ETF	150.76	150.76	150.7	150.71	10700.0
2007-06-22 19:00:00	SPY	ETF	150.71	150.71	150.7	150.7	1300.0
2007-06-22 19:30:00	SPY	ETF	150.7	150.72	150.7	150.72	1000.0
2007-06-22 04:30:00	QQQ	ETF	47.58	47.6	47.58	47.6	72700.0
2007-06-22 05:00:00	QQQ	ETF	47.6	47.6	47.6	47.6	7400.0
2007-06-22 06:30:00	QQQ	ETF	47.6	47.6	47.6	47.6	5000.0
2007-06-22 07:00:00	QQQ	ETF	47.58	47.67	47.58	47.67	73850.0
2007-06-22 07:30:00	QQQ	ETF	47.68	47.72	47.52	47.55	433751.0
2007-06-22 08:00:00	QQQ	ETF	47.55	47.62	47.52	47.55	1250033.0
2007-06-22 08:30:00	QQQ	ETF	47.58	47.64	47.58	47.61	595171.0
2007-06-22 09:00:00	QQQ	ETF	47.61	47.64	47.59	47.63	233847.0
2007-06-22 09:30:00	QQQ	ETF	47.64	47.71	47.49	47.62	12116537.0
2007-06-22 10:00:00	QQQ	ETF	47.62	47.63	47.48	47.5	11205133.0
2007-06-22 10:30:00	QQQ	ETF	47.5	47.65	47.45	47.58	10773127.0
2007-06-22 11:00:00	QQQ	ETF	47.58	47.59	47.47	47.51	7566094.0
2007-06-22 11:30:00	QQQ	ETF	47.51	47.57	47.36	47.5115	16097633.0
2007-06-22 12:00:00	QQQ	ETF	47.51	47.53	47.25	47.2601	9324768.0
2007-06-22 12:30:00	QQQ	ETF	47.27	47.35	47.19	47.295	19523251.0
2007-06-22 13:00:00	QQQ	ETF	47.29	47.39	47.14	47.36	12969275.0
2007-06-22 13:30:00	QQQ	ETF	47.36	47.39	47.27	47.32	7520033.0
2007-06-22 14:00:00	QQQ	ETF	47.32	47.36	47.24	47.36	8022063.0
2007-06-22 14:30:00	QQQ	ETF	47.35	47.39	47.31	47.34	5091101.0
2007-06-22 15:00:00	QQQ	ETF	47.35	47.41	47.3	47.31	5107498.0
2007-06-22 15:30:00	QQQ	ETF	47.31	47.35	47.155	47.32	18941961.0

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

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