PREVIEW / etf_30min / 2007-10-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-05.parquet
  size:    131 KB
  rows:    4,866

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-10-05 05:30:00	SPY	ETF	154.38	154.38	154.38	154.38	10000.0
2007-10-05 06:00:00	SPY	ETF	154.5	154.5	154.48	154.48	2600.0
2007-10-05 06:30:00	SPY	ETF	154.52	154.53	154.52	154.53	50000.0
2007-10-05 07:00:00	SPY	ETF	154.43	154.51	154.41	154.48	144800.0
2007-10-05 07:30:00	SPY	ETF	154.46	154.68	154.45	154.62	376800.0
2007-10-05 08:00:00	SPY	ETF	154.62	154.76	153.79	154.69	1015800.0
2007-10-05 08:30:00	SPY	ETF	154.68	155.25	154.45	155.01	14307200.0
2007-10-05 09:00:00	SPY	ETF	155.01	155.08	154.68	155.02	4365429.0
2007-10-05 09:30:00	SPY	ETF	155.03	155.14	154.76	154.93	12537977.0
2007-10-05 10:00:00	SPY	ETF	154.92	155.06	154.72	154.74	7965300.0
2007-10-05 10:30:00	SPY	ETF	154.73	155.02	154.63	154.93	10549500.0
2007-10-05 11:00:00	SPY	ETF	154.92	155.33	154.92	155.18	10681900.0
2007-10-05 11:30:00	SPY	ETF	155.18	155.53	155.18	155.49	6756300.0
2007-10-05 12:00:00	SPY	ETF	155.5	155.505	155.35	155.375	3119300.0
2007-10-05 12:30:00	SPY	ETF	155.37	155.49	155.33	155.409	2502100.0
2007-10-05 13:00:00	SPY	ETF	155.4	155.51	155.27	155.441	6859000.0
2007-10-05 13:30:00	SPY	ETF	155.43	155.8	155.4	155.69	10338900.0
2007-10-05 14:00:00	SPY	ETF	155.69	156.0	155.69	155.93	6832300.0
2007-10-05 14:30:00	SPY	ETF	155.93	156.07	155.83	155.99	7976500.0
2007-10-05 15:00:00	SPY	ETF	155.98	156.1	155.73	155.799	8289900.0
2007-10-05 15:30:00	SPY	ETF	155.79	155.9	155.49	155.6	13300800.0
2007-10-05 16:00:00	SPY	ETF	155.63	155.87	155.61	155.85	2537700.0
2007-10-05 16:30:00	SPY	ETF	155.06	156.0	154.16	155.94	2113100.0
2007-10-05 17:00:00	SPY	ETF	155.97	156.06	155.92	156.03	37800.0
2007-10-05 17:30:00	SPY	ETF	156.0	156.04	155.95	156.04	1900.0
2007-10-05 18:00:00	SPY	ETF	156.0	156.0	156.0	156.0	1300.0
2007-10-05 18:30:00	SPY	ETF	155.95	155.95	155.95	155.95	100.0
2007-10-05 19:30:00	SPY	ETF	156.0	156.0	156.0	156.0	1500.0
2007-10-05 04:00:00	QQQ	ETF	51.8	51.8	51.8	51.8	100.0
2007-10-05 06:00:00	QQQ	ETF	51.8	51.8	51.8	51.8	100.0
2007-10-05 07:00:00	QQQ	ETF	51.8	51.85	51.79	51.83	88368.0
2007-10-05 07:30:00	QQQ	ETF	51.83	51.94	51.83	51.91	145443.0
2007-10-05 08:00:00	QQQ	ETF	51.91	51.96	51.8	51.9	1655003.0
2007-10-05 08:30:00	QQQ	ETF	51.9	52.18	51.89	52.08	6718777.0
2007-10-05 09:00:00	QQQ	ETF	52.09	52.17	52.0	52.17	2008128.0
2007-10-05 09:30:00	QQQ	ETF	52.17	52.26	52.06	52.14	15455546.0
2007-10-05 10:00:00	QQQ	ETF	52.14	52.35	52.07	52.16	14125037.0
2007-10-05 10:30:00	QQQ	ETF	52.168	52.34	52.14	52.3372	7514860.0
2007-10-05 11:00:00	QQQ	ETF	52.3325	52.57	52.3325	52.5	11853104.0
2007-10-05 11:30:00	QQQ	ETF	52.5085	52.7	52.49	52.679	11700079.0
2007-10-05 12:00:00	QQQ	ETF	52.67	52.69	52.6	52.64	4798781.0
2007-10-05 12:30:00	QQQ	ETF	52.65	52.7	52.62	52.6726	2267059.0
2007-10-05 13:00:00	QQQ	ETF	52.68	52.71	52.61	52.68	3258824.0
2007-10-05 13:30:00	QQQ	ETF	52.67	52.85	52.66	52.7885	6234240.0
2007-10-05 14:00:00	QQQ	ETF	52.79	52.87	52.77	52.84	3692270.0
2007-10-05 14:30:00	QQQ	ETF	52.85	52.9	52.8	52.8391	4849350.0
2007-10-05 15:00:00	QQQ	ETF	52.83	52.86	52.71	52.782	6162991.0
2007-10-05 15:30:00	QQQ	ETF	52.78	52.83	52.69	52.82	11476026.0
2007-10-05 16:00:00	QQQ	ETF	52.83	52.91	52.38	52.9	1825493.0
2007-10-05 16:30:00	QQQ	ETF	52.91	52.98	52.88	52.94	89199.0

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

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