PREVIEW / etf_30min / 2008-08-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-07.parquet
  size:    167 KB
  rows:    5,853

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-08-07 04:00:00	SPY	ETF	128.75	128.75	128.75	128.75	100.0
2008-08-07 04:30:00	SPY	ETF	128.86	128.86	128.86	128.86	500.0
2008-08-07 05:30:00	SPY	ETF	128.77	128.77	128.76	128.76	5000.0
2008-08-07 06:00:00	SPY	ETF	128.64	128.83	128.64	128.64	13000.0
2008-08-07 06:30:00	SPY	ETF	128.65	128.65	128.54	128.56	145500.0
2008-08-07 07:00:00	SPY	ETF	128.55	128.73	128.24	128.39	634595.0
2008-08-07 07:30:00	SPY	ETF	128.35	128.52	128.27	128.41	713286.0
2008-08-07 08:00:00	SPY	ETF	128.41	128.51	128.24	128.35	2940429.0
2008-08-07 08:30:00	SPY	ETF	128.36	128.36	127.89	128.1	5067474.0
2008-08-07 09:00:00	SPY	ETF	128.07	128.13	127.95	127.96	1942153.0
2008-08-07 09:30:00	SPY	ETF	127.96	128.93	127.33	127.92	26201061.0
2008-08-07 10:00:00	SPY	ETF	127.91	128.41	127.84	128.15	25468336.0
2008-08-07 10:30:00	SPY	ETF	128.16	128.33	127.87	128.21	13774027.0
2008-08-07 11:00:00	SPY	ETF	128.21	129.0549	127.59	128.01	14025652.0
2008-08-07 11:30:00	SPY	ETF	128.01	128.13	127.58	127.88	7098253.0
2008-08-07 12:00:00	SPY	ETF	127.89	128.06	127.72	128.02	7288779.0
2008-08-07 12:30:00	SPY	ETF	128.02	128.44	127.92	128.31	14581690.0
2008-08-07 13:00:00	SPY	ETF	128.311	128.36	128.05	128.24	9047140.0
2008-08-07 13:30:00	SPY	ETF	128.24	128.39	127.96	127.97	12017989.0
2008-08-07 14:00:00	SPY	ETF	127.98	128.06	127.8	127.91	13476265.0
2008-08-07 14:30:00	SPY	ETF	127.9	128.11	127.43	127.43	15435456.0
2008-08-07 15:00:00	SPY	ETF	127.44	127.82	127.11	127.28	19397841.0
2008-08-07 15:30:00	SPY	ETF	127.28	128.12	126.54	126.88	40491974.0
2008-08-07 16:00:00	SPY	ETF	126.91	127.92	126.79	126.96	6908922.0
2008-08-07 16:30:00	SPY	ETF	126.97	129.055	126.96	127.05	3815431.0
2008-08-07 17:00:00	SPY	ETF	127.05	127.09	127.02	127.05	67824.0
2008-08-07 17:30:00	SPY	ETF	127.08	127.08	127.03	127.05	15904.0
2008-08-07 18:00:00	SPY	ETF	127.03	127.03	126.98	126.98	55650.0
2008-08-07 18:30:00	SPY	ETF	126.98	127.01	126.97	126.98	39580.0
2008-08-07 19:00:00	SPY	ETF	127.01	127.01	126.94	126.97	17881.0
2008-08-07 19:30:00	SPY	ETF	126.99	127.0	126.95	126.95	7906.0
2008-08-07 06:30:00	QQQ	ETF	46.54	46.54	46.54	46.54	200.0
2008-08-07 07:00:00	QQQ	ETF	46.54	46.54	46.42	46.45	38300.0
2008-08-07 07:30:00	QQQ	ETF	46.47	46.5	46.44	46.49	40080.0
2008-08-07 08:00:00	QQQ	ETF	46.48	46.48	46.38	46.42	1518205.0
2008-08-07 08:30:00	QQQ	ETF	46.41	46.41	46.25	46.3	2555684.0
2008-08-07 09:00:00	QQQ	ETF	46.3	46.36	46.27	46.35	563446.0
2008-08-07 09:30:00	QQQ	ETF	46.35	46.44	46.08	46.41	21852289.0
2008-08-07 10:00:00	QQQ	ETF	46.4	46.59	46.32	46.48	14376344.0
2008-08-07 10:30:00	QQQ	ETF	46.48	46.52	46.32	46.51	7809917.0
2008-08-07 11:00:00	QQQ	ETF	46.52	46.55	46.38	46.47	6325684.0
2008-08-07 11:30:00	QQQ	ETF	46.47	46.64	46.41	46.538	4948996.0
2008-08-07 12:00:00	QQQ	ETF	46.53	46.6	46.45	46.59	4636641.0
2008-08-07 12:30:00	QQQ	ETF	46.588	46.85	46.55	46.8	9784756.0
2008-08-07 13:00:00	QQQ	ETF	46.81	46.81	46.68	46.778	4515570.0
2008-08-07 13:30:00	QQQ	ETF	46.77	46.82	46.57	46.57	7426913.0
2008-08-07 14:00:00	QQQ	ETF	46.58	46.71	46.44	46.4895	8700315.0
2008-08-07 14:30:00	QQQ	ETF	46.49	46.61	46.33	46.35	8894138.0
2008-08-07 15:00:00	QQQ	ETF	46.35	46.41	46.25	46.38	10233683.0
2008-08-07 15:30:00	QQQ	ETF	46.37	46.37	46.12	46.27	22632958.0

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

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