PREVIEW / etf_30min / 2008-04-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-15.parquet
  size:    159 KB
  rows:    5,557

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
2008-04-15 05:00:00	SPY	ETF	132.75	132.75	132.75	132.75	100.0
2008-04-15 06:30:00	SPY	ETF	132.71	132.71	132.67	132.7	18300.0
2008-04-15 07:00:00	SPY	ETF	132.53	132.91	132.51	132.89	667700.0
2008-04-15 07:30:00	SPY	ETF	132.92	133.2	132.92	133.13	861590.0
2008-04-15 08:00:00	SPY	ETF	133.13	133.49	132.73	132.99	1861938.0
2008-04-15 08:30:00	SPY	ETF	133.15	133.67	132.71	133.67	6367581.0
2008-04-15 09:00:00	SPY	ETF	133.65	133.7	133.48	133.58	2277107.0
2008-04-15 09:30:00	SPY	ETF	133.58	133.69	133.17	133.18	14032767.0
2008-04-15 10:00:00	SPY	ETF	133.19	133.58	132.78	132.79	16237846.0
2008-04-15 10:30:00	SPY	ETF	132.79	133.05	132.76	133.01	16531520.0
2008-04-15 11:00:00	SPY	ETF	133.01	133.04	132.33	132.43	15318437.0
2008-04-15 11:30:00	SPY	ETF	132.42	132.85	132.34	132.55	10430944.0
2008-04-15 12:00:00	SPY	ETF	132.55	132.7	132.42	132.69	6009575.0
2008-04-15 12:30:00	SPY	ETF	132.68	132.79	132.6	132.69	7451667.0
2008-04-15 13:00:00	SPY	ETF	132.68	133.07	132.63	132.91	9956973.0
2008-04-15 13:30:00	SPY	ETF	132.92	133.28	132.76	133.19	10289555.0
2008-04-15 14:00:00	SPY	ETF	133.19	133.25	132.99	133.04	6936075.0
2008-04-15 14:30:00	SPY	ETF	133.05	133.28	132.76	132.85	10200270.0
2008-04-15 15:00:00	SPY	ETF	132.84	133.25	132.79	133.18	10698958.0
2008-04-15 15:30:00	SPY	ETF	133.18	133.56	132.96	133.5	17079834.0
2008-04-15 16:00:00	SPY	ETF	133.5101	134.19	132.5	134.06	3797916.0
2008-04-15 16:30:00	SPY	ETF	134.1	134.27	133.24	134.01	2522802.0
2008-04-15 17:00:00	SPY	ETF	133.99	134.27	133.9	134.22	677153.0
2008-04-15 17:30:00	SPY	ETF	134.2	134.24	134.13	134.2	118266.0
2008-04-15 18:00:00	SPY	ETF	134.21	134.21	134.05	134.06	104624.0
2008-04-15 18:30:00	SPY	ETF	134.06	134.12	134.02	134.02	3650.0
2008-04-15 19:00:00	SPY	ETF	134.05	134.07	133.91	133.97	27900.0
2008-04-15 19:30:00	SPY	ETF	133.97	134.03	133.96	134.01	16069.0
2008-04-15 06:00:00	QQQ	ETF	44.0	44.0	43.95	43.95	1000.0
2008-04-15 06:30:00	QQQ	ETF	43.98	43.98	43.97	43.97	300.0
2008-04-15 07:00:00	QQQ	ETF	43.95	44.07	43.93	44.07	64789.0
2008-04-15 07:30:00	QQQ	ETF	44.07	44.21	44.07	44.16	976921.0
2008-04-15 08:00:00	QQQ	ETF	44.16	44.23	44.08	44.08	695020.0
2008-04-15 08:30:00	QQQ	ETF	44.08	44.39	44.05	44.32	1970578.0
2008-04-15 09:00:00	QQQ	ETF	44.31	44.31	44.22	44.23	529841.0
2008-04-15 09:30:00	QQQ	ETF	44.24	44.35	44.1	44.1	13228195.0
2008-04-15 10:00:00	QQQ	ETF	44.11	44.21	43.97	43.98	8201585.0
2008-04-15 10:30:00	QQQ	ETF	43.98	44.03	43.81	43.9	18442759.0
2008-04-15 11:00:00	QQQ	ETF	43.9	43.94	43.68	43.77	10227019.0
2008-04-15 11:30:00	QQQ	ETF	43.76	43.87	43.71	43.8	5982972.0
2008-04-15 12:00:00	QQQ	ETF	43.8	43.89	43.75	43.88	4051126.0
2008-04-15 12:30:00	QQQ	ETF	43.88	43.94	43.83	43.89	5708461.0
2008-04-15 13:00:00	QQQ	ETF	43.89	44.03	43.83	43.99	7186370.0
2008-04-15 13:30:00	QQQ	ETF	44.0	44.12	43.9105	44.07	6674340.0
2008-04-15 14:00:00	QQQ	ETF	44.0799	44.1	44.0	44.0381	5005178.0
2008-04-15 14:30:00	QQQ	ETF	44.03	44.13	43.9	43.94	6901290.0
2008-04-15 15:00:00	QQQ	ETF	43.93	44.15	43.91	44.14	6319814.0
2008-04-15 15:30:00	QQQ	ETF	44.13	44.2	44.0	44.14	9226856.0
2008-04-15 16:00:00	QQQ	ETF	44.15	44.81	43.75	44.72	6507578.0
2008-04-15 16:30:00	QQQ	ETF	44.72	44.72	44.57	44.61	3983954.0

> showing 50 of 5,557 rows — these rows as CSV

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