PREVIEW / etf_30min / 2007-01-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-30.parquet
  size:    95 KB
  rows:    3,345

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-30 07:00:00	SPY	ETF	142.24	142.46	142.22	142.42	47500.0
2007-01-30 07:30:00	SPY	ETF	142.42	142.5	142.4	142.5	448300.0
2007-01-30 08:00:00	SPY	ETF	142.5	142.54	142.05	142.42	1189900.0
2007-01-30 08:30:00	SPY	ETF	142.39	142.4	142.26	142.32	469000.0
2007-01-30 09:00:00	SPY	ETF	142.31	142.35	142.24	142.35	424000.0
2007-01-30 09:30:00	SPY	ETF	142.35	142.41	142.06	142.14	7976300.0
2007-01-30 10:00:00	SPY	ETF	142.14	142.43	142.1	142.34	5676400.0
2007-01-30 10:30:00	SPY	ETF	142.34	142.48	142.16	142.31	3662700.0
2007-01-30 11:00:00	SPY	ETF	142.31	142.76	142.26	142.61	11957200.0
2007-01-30 11:30:00	SPY	ETF	142.62	142.74	142.54	142.56	3386400.0
2007-01-30 12:00:00	SPY	ETF	142.56	142.63	142.42	142.49	4108200.0
2007-01-30 12:30:00	SPY	ETF	142.49	142.59	142.44	142.58	1821900.0
2007-01-30 13:00:00	SPY	ETF	142.59	142.59	142.34	142.54	3612000.0
2007-01-30 13:30:00	SPY	ETF	142.54	142.66	142.45	142.61	2536000.0
2007-01-30 14:00:00	SPY	ETF	142.61	142.64	142.44	142.59	1882300.0
2007-01-30 14:30:00	SPY	ETF	142.58	142.7	142.5	142.64	9126400.0
2007-01-30 15:00:00	SPY	ETF	142.65	142.76	142.61	142.66	3510700.0
2007-01-30 15:30:00	SPY	ETF	142.66	142.83	142.6	142.76	4500000.0
2007-01-30 16:00:00	SPY	ETF	142.75	142.85	141.994	142.81	2313000.0
2007-01-30 16:30:00	SPY	ETF	142.8	142.83	142.8	142.83	44000.0
2007-01-30 17:00:00	SPY	ETF	142.84	142.87	142.75	142.8	199500.0
2007-01-30 17:30:00	SPY	ETF	142.79	142.84	142.79	142.84	2400.0
2007-01-30 18:00:00	SPY	ETF	142.8	142.8	142.8	142.8	2800.0
2007-01-30 18:30:00	SPY	ETF	142.84	142.84	142.8	142.8	600.0
2007-01-30 19:00:00	SPY	ETF	142.8	142.8	142.8	142.8	1800.0
2007-01-30 19:30:00	SPY	ETF	142.85	142.85	142.77	142.83	11100.0
2007-01-30 07:00:00	QQQ	ETF	43.72	43.76	43.7	43.76	66439.0
2007-01-30 07:30:00	QQQ	ETF	43.75	43.8	43.74	43.8	133761.0
2007-01-30 08:00:00	QQQ	ETF	43.8	43.8	43.74	43.77	244201.0
2007-01-30 08:30:00	QQQ	ETF	43.76	43.76	43.71	43.71	245037.0
2007-01-30 09:00:00	QQQ	ETF	43.72	43.72	43.65	43.68	694455.0
2007-01-30 09:30:00	QQQ	ETF	43.68	43.71	43.53	43.63	8787200.0
2007-01-30 10:00:00	QQQ	ETF	43.63	43.71	43.58	43.67	7561600.0
2007-01-30 10:30:00	QQQ	ETF	43.68	43.72	43.58	43.65	4559600.0
2007-01-30 11:00:00	QQQ	ETF	43.66	43.79	43.62	43.71	6849400.0
2007-01-30 11:30:00	QQQ	ETF	43.71	43.77	43.66	43.66	3615200.0
2007-01-30 12:00:00	QQQ	ETF	43.66	43.67	43.56	43.61	5038000.0
2007-01-30 12:30:00	QQQ	ETF	43.6	43.66	43.59	43.64	2600100.0
2007-01-30 13:00:00	QQQ	ETF	43.64	43.65	43.52	43.6	6470400.0
2007-01-30 13:30:00	QQQ	ETF	43.59	43.68	43.57	43.65	3182500.0
2007-01-30 14:00:00	QQQ	ETF	43.65	43.66	43.56	43.61	2072700.0
2007-01-30 14:30:00	QQQ	ETF	43.61	43.63	43.56	43.61	2687100.0
2007-01-30 15:00:00	QQQ	ETF	43.61	43.67	43.6	43.63	4414100.0
2007-01-30 15:30:00	QQQ	ETF	43.62	43.7	43.59	43.68	5102600.0
2007-01-30 16:00:00	QQQ	ETF	43.68	43.72	43.66	43.72	1574651.0
2007-01-30 16:30:00	QQQ	ETF	43.7	43.73	43.7	43.71	74838.0
2007-01-30 17:00:00	QQQ	ETF	43.71	43.74	43.71	43.71	30020.0
2007-01-30 17:30:00	QQQ	ETF	43.71	43.71	43.66	43.67	79525.0
2007-01-30 18:00:00	QQQ	ETF	43.69	43.69	43.6	43.66	335915.0
2007-01-30 18:30:00	QQQ	ETF	43.67	43.68	43.66	43.68	4700.0

> showing 50 of 3,345 rows — these rows as CSV

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