PREVIEW / etf_30min / 2008-06-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-10.parquet
  size:    169 KB
  rows:    5,832

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-06-10 04:00:00	SPY	ETF	135.72	135.72	135.5	135.5	600.0
2008-06-10 04:30:00	SPY	ETF	135.52	135.52	135.25	135.32	3600.0
2008-06-10 05:00:00	SPY	ETF	135.57	135.57	135.57	135.57	5000.0
2008-06-10 05:30:00	SPY	ETF	135.63	135.9	135.63	135.85	126100.0
2008-06-10 06:00:00	SPY	ETF	135.85	136.02	135.81	135.83	269269.0
2008-06-10 06:30:00	SPY	ETF	135.83	135.93	135.61	135.79	524450.0
2008-06-10 07:00:00	SPY	ETF	135.84	135.95	135.72	135.75	828030.0
2008-06-10 07:30:00	SPY	ETF	135.7	135.76	135.45	135.6	866400.0
2008-06-10 08:00:00	SPY	ETF	135.6	135.69	135.18	135.52	4635490.0
2008-06-10 08:30:00	SPY	ETF	135.52	135.67	135.35	135.52	930909.0
2008-06-10 09:00:00	SPY	ETF	135.51	135.68	135.27	135.66	2041470.0
2008-06-10 09:30:00	SPY	ETF	135.67	136.08	135.52	135.78	32186770.0
2008-06-10 10:00:00	SPY	ETF	135.78	136.51	135.65	136.34	26808056.0
2008-06-10 10:30:00	SPY	ETF	136.34	136.39	135.9	136.07	15052689.0
2008-06-10 11:00:00	SPY	ETF	136.08	136.561	135.72	135.96	19554241.0
2008-06-10 11:30:00	SPY	ETF	135.96	136.68	135.87	136.22	22491006.0
2008-06-10 12:00:00	SPY	ETF	136.22	136.79	135.99	136.6	14260675.0
2008-06-10 12:30:00	SPY	ETF	136.61	136.82	136.47	136.61	13593241.0
2008-06-10 13:00:00	SPY	ETF	136.61	137.1	136.43	137.0	14633085.0
2008-06-10 13:30:00	SPY	ETF	136.99	137.01	136.47	136.5	12404135.0
2008-06-10 14:00:00	SPY	ETF	136.5	136.57	135.81	136.16	21625584.0
2008-06-10 14:30:00	SPY	ETF	136.17	136.48	136.05	136.38	13598033.0
2008-06-10 15:00:00	SPY	ETF	136.38	136.605	136.26	136.49	13082761.0
2008-06-10 15:30:00	SPY	ETF	136.49	136.66	136.11	136.14	16892862.0
2008-06-10 16:00:00	SPY	ETF	136.14	136.561	135.89	136.02	8737589.0
2008-06-10 16:30:00	SPY	ETF	136.0	136.561	135.93	135.94	1313543.0
2008-06-10 17:00:00	SPY	ETF	135.94	136.02	135.94	136.02	42946.0
2008-06-10 17:30:00	SPY	ETF	135.97	135.97	135.94	135.94	27230.0
2008-06-10 18:00:00	SPY	ETF	135.93	135.93	135.76	135.79	51165.0
2008-06-10 18:30:00	SPY	ETF	135.83	135.95	135.83	135.95	13054.0
2008-06-10 19:00:00	SPY	ETF	135.95	135.95	135.94	135.95	2000.0
2008-06-10 19:30:00	SPY	ETF	135.96	136.04	135.96	136.04	3000.0
2008-06-10 05:30:00	QQQ	ETF	48.45	48.53	48.45	48.52	2300.0
2008-06-10 06:00:00	QQQ	ETF	48.48	48.53	48.48	48.53	1600.0
2008-06-10 06:30:00	QQQ	ETF	48.51	48.51	48.43	48.43	105000.0
2008-06-10 07:00:00	QQQ	ETF	48.5	48.59	48.47	48.48	197134.0
2008-06-10 07:30:00	QQQ	ETF	48.48	48.49	48.4	48.42	478399.0
2008-06-10 08:00:00	QQQ	ETF	48.44	48.45	48.25	48.27	1705440.0
2008-06-10 08:30:00	QQQ	ETF	48.28	48.31	48.16	48.2	2846622.0
2008-06-10 09:00:00	QQQ	ETF	48.19	48.28	48.12	48.28	1124173.0
2008-06-10 09:30:00	QQQ	ETF	48.27	48.4799	48.16	48.39	19603651.0
2008-06-10 10:00:00	QQQ	ETF	48.39	48.6	48.22	48.5	18785584.0
2008-06-10 10:30:00	QQQ	ETF	48.505	48.525	48.28	48.44	9387523.0
2008-06-10 11:00:00	QQQ	ETF	48.43	48.56	48.3	48.33	10526665.0
2008-06-10 11:30:00	QQQ	ETF	48.33	48.57	48.24	48.4	13293753.0
2008-06-10 12:00:00	QQQ	ETF	48.41	48.7	48.33	48.6	9413453.0
2008-06-10 12:30:00	QQQ	ETF	48.61	48.81	48.6	48.7	10209333.0
2008-06-10 13:00:00	QQQ	ETF	48.7	48.94	48.59	48.91	10218183.0
2008-06-10 13:30:00	QQQ	ETF	48.91	48.91	48.665	48.69	7910542.0
2008-06-10 14:00:00	QQQ	ETF	48.69	48.7	48.37	48.54	14699707.0

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

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