PREVIEW / etf_30min / 2008-01-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-08.parquet
  size:    158 KB
  rows:    5,656

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-01-08 04:30:00	SPY	ETF	141.89	141.89	141.89	141.89	200.0
2008-01-08 06:00:00	SPY	ETF	141.9	142.0	141.9	142.0	51000.0
2008-01-08 06:30:00	SPY	ETF	141.89	142.02	141.89	141.95	99500.0
2008-01-08 07:00:00	SPY	ETF	141.95	142.29	141.93	142.23	731400.0
2008-01-08 07:30:00	SPY	ETF	142.18	142.48	142.16	142.48	343500.0
2008-01-08 08:00:00	SPY	ETF	142.43	142.5	142.03	142.21	3341500.0
2008-01-08 08:30:00	SPY	ETF	142.19	142.32	141.95	142.1	1002900.0
2008-01-08 09:00:00	SPY	ETF	142.09	142.18	141.91	142.1	3253800.0
2008-01-08 09:30:00	SPY	ETF	142.08	142.63	141.86	142.36	31230791.0
2008-01-08 10:00:00	SPY	ETF	142.36	142.9	142.1	142.49	22986474.0
2008-01-08 10:30:00	SPY	ETF	142.49	142.55	142.18	142.27	11855280.0
2008-01-08 11:00:00	SPY	ETF	142.27	142.38	141.54	141.65	16778155.0
2008-01-08 11:30:00	SPY	ETF	141.65	141.66	140.88	141.18	19211720.0
2008-01-08 12:00:00	SPY	ETF	141.18	141.51	140.92	141.45	13846795.0
2008-01-08 12:30:00	SPY	ETF	141.44	141.5	141.0	141.25	9072995.0
2008-01-08 13:00:00	SPY	ETF	141.245	141.99	140.9	141.82	30609181.0
2008-01-08 13:30:00	SPY	ETF	141.82	142.05	141.34	142.04	13776858.0
2008-01-08 14:00:00	SPY	ETF	142.03	142.35	141.88	142.34	12801470.0
2008-01-08 14:30:00	SPY	ETF	142.34	142.36	140.63	140.7	27590857.0
2008-01-08 15:00:00	SPY	ETF	140.7	141.55	139.3	139.86	46265166.0
2008-01-08 15:30:00	SPY	ETF	139.86	140.45	138.63	138.81	47097628.0
2008-01-08 16:00:00	SPY	ETF	138.85	141.3	138.44	138.83	7947400.0
2008-01-08 16:30:00	SPY	ETF	138.83	138.85	138.63	138.84	1375300.0
2008-01-08 17:00:00	SPY	ETF	138.82	138.97	138.78	138.96	171000.0
2008-01-08 17:30:00	SPY	ETF	141.04	141.31	138.86	138.86	152500.0
2008-01-08 18:00:00	SPY	ETF	138.89	138.92	138.77	138.78	27900.0
2008-01-08 18:30:00	SPY	ETF	138.78	138.88	138.67	138.67	31800.0
2008-01-08 19:00:00	SPY	ETF	138.74	138.9	138.72	138.9	3600.0
2008-01-08 19:30:00	SPY	ETF	138.95	138.99	138.91	138.91	12200.0
2008-01-08 05:00:00	QQQ	ETF	48.39	48.41	48.39	48.41	25300.0
2008-01-08 06:00:00	QQQ	ETF	48.35	48.35	48.35	48.35	2600.0
2008-01-08 06:30:00	QQQ	ETF	48.38	48.38	48.38	48.38	600.0
2008-01-08 07:00:00	QQQ	ETF	48.37	48.48	48.37	48.48	705070.0
2008-01-08 07:30:00	QQQ	ETF	48.48	48.62	48.48	48.59	553564.0
2008-01-08 08:00:00	QQQ	ETF	48.59	48.61	48.35	48.47	2761693.0
2008-01-08 08:30:00	QQQ	ETF	48.46	48.5	48.35	48.38	1571117.0
2008-01-08 09:00:00	QQQ	ETF	48.38	48.39	48.11	48.29	1472288.0
2008-01-08 09:30:00	QQQ	ETF	48.29	48.45	48.19	48.33	18949166.0
2008-01-08 10:00:00	QQQ	ETF	48.33	48.76	48.28	48.618	19317877.0
2008-01-08 10:30:00	QQQ	ETF	48.6	48.65	48.46	48.54	11360628.0
2008-01-08 11:00:00	QQQ	ETF	48.54	48.58	48.22	48.29	11873285.0
2008-01-08 11:30:00	QQQ	ETF	48.29	48.32	47.99	48.17	14719647.0
2008-01-08 12:00:00	QQQ	ETF	48.19	48.35	48.05	48.31	11512274.0
2008-01-08 12:30:00	QQQ	ETF	48.31	48.39	48.11	48.3	8454989.0
2008-01-08 13:00:00	QQQ	ETF	48.3	48.53	48.13	48.51	14449669.0
2008-01-08 13:30:00	QQQ	ETF	48.5	48.64	48.27	48.53	10770764.0
2008-01-08 14:00:00	QQQ	ETF	48.52	48.74	48.4501	48.74	14363722.0
2008-01-08 14:30:00	QQQ	ETF	48.74	48.76	48.04	48.07	20674632.0
2008-01-08 15:00:00	QQQ	ETF	48.07	48.15	47.33	47.5	39879690.0
2008-01-08 15:30:00	QQQ	ETF	47.5	48.76	46.97	46.98	40395105.0

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

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