PREVIEW / etf_30min / 2007-08-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-06.parquet
  size:    137 KB
  rows:    5,011

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-08-06 05:30:00	SPY	ETF	144.52	144.54	144.48	144.54	18000.0
2007-08-06 06:00:00	SPY	ETF	144.72	144.9	144.67	144.78	3300.0
2007-08-06 06:30:00	SPY	ETF	144.7	144.95	144.7	144.87	52800.0
2007-08-06 07:00:00	SPY	ETF	144.84	144.93	144.79	144.84	758600.0
2007-08-06 07:30:00	SPY	ETF	144.85	144.89	144.34	144.46	1419300.0
2007-08-06 08:00:00	SPY	ETF	144.5	144.89	143.0	144.27	4057400.0
2007-08-06 08:30:00	SPY	ETF	144.58	144.58	143.2	144.4	1772200.0
2007-08-06 09:00:00	SPY	ETF	144.4	144.51	144.19	144.21	1307110.0
2007-08-06 09:30:00	SPY	ETF	144.21	144.44	142.94	144.11	46378083.0
2007-08-06 10:00:00	SPY	ETF	144.12	144.19	143.04	143.16	29600250.0
2007-08-06 10:30:00	SPY	ETF	143.16	144.21	142.53	143.22	25091971.0
2007-08-06 11:00:00	SPY	ETF	143.23	143.97	142.94	143.87	25635550.0
2007-08-06 11:30:00	SPY	ETF	143.87	144.71	143.57	144.28	23657110.0
2007-08-06 12:00:00	SPY	ETF	144.29	144.41	143.73	144.25	11048754.0
2007-08-06 12:30:00	SPY	ETF	144.25	145.18	144.24	144.87	18918976.0
2007-08-06 13:00:00	SPY	ETF	144.87	144.88	144.03	144.47	16422306.0
2007-08-06 13:30:00	SPY	ETF	144.47	144.75	144.01	144.08	10916098.0
2007-08-06 14:00:00	SPY	ETF	144.08	144.91	144.05	144.49	10923339.0
2007-08-06 14:30:00	SPY	ETF	144.5	145.6	144.49	145.2	20623257.0
2007-08-06 15:00:00	SPY	ETF	145.2	145.99	145.14	145.85	21008733.0
2007-08-06 15:30:00	SPY	ETF	145.85	146.83	145.54	146.77	30529528.0
2007-08-06 16:00:00	SPY	ETF	146.72	146.865	142.8	146.34	16754500.0
2007-08-06 16:30:00	SPY	ETF	146.31	146.47	146.28	146.41	683100.0
2007-08-06 17:00:00	SPY	ETF	146.4	146.5	146.4	146.43	862100.0
2007-08-06 17:30:00	SPY	ETF	146.42	146.42	146.25	146.31	108000.0
2007-08-06 18:00:00	SPY	ETF	146.32	146.4	146.31	146.36	26200.0
2007-08-06 18:30:00	SPY	ETF	146.31	146.39	146.31	146.34	7000.0
2007-08-06 19:00:00	SPY	ETF	146.34	146.34	146.21	146.27	245100.0
2007-08-06 19:30:00	SPY	ETF	146.27	146.32	146.24	146.32	3500.0
2007-08-06 06:30:00	QQQ	ETF	47.66	47.66	47.64	47.64	7700.0
2007-08-06 07:00:00	QQQ	ETF	47.67	47.69	47.64	47.64	6450.0
2007-08-06 07:30:00	QQQ	ETF	47.64	47.66	47.54	47.57	223951.0
2007-08-06 08:00:00	QQQ	ETF	47.57	48.0	47.46	47.53	508310.0
2007-08-06 08:30:00	QQQ	ETF	47.51	47.55	47.48	47.5	310057.0
2007-08-06 09:00:00	QQQ	ETF	47.5	47.52	47.45	47.46	818286.0
2007-08-06 09:30:00	QQQ	ETF	47.46	47.59	47.07	47.44	25863345.0
2007-08-06 10:00:00	QQQ	ETF	47.43	47.45	47.08	47.08	23395600.0
2007-08-06 10:30:00	QQQ	ETF	47.08	47.38	47.03	47.16	18058449.0
2007-08-06 11:00:00	QQQ	ETF	47.16	47.35	47.05	47.32	13970646.0
2007-08-06 11:30:00	QQQ	ETF	47.32	47.58	47.17	47.41	17454083.0
2007-08-06 12:00:00	QQQ	ETF	47.42	47.46	47.32	47.4122	8504029.0
2007-08-06 12:30:00	QQQ	ETF	47.42	47.77	47.35	47.67	15955765.0
2007-08-06 13:00:00	QQQ	ETF	47.67	47.69	47.44	47.51	7372962.0
2007-08-06 13:30:00	QQQ	ETF	47.5	47.54	47.33	47.38	6063789.0
2007-08-06 14:00:00	QQQ	ETF	47.37	47.66	47.352	47.56	10942540.0
2007-08-06 14:30:00	QQQ	ETF	47.55	47.85	47.55	47.7222	10164440.0
2007-08-06 15:00:00	QQQ	ETF	47.72	47.86	47.7	47.83	6952179.0
2007-08-06 15:30:00	QQQ	ETF	47.83	48.02	47.7	47.98	15173600.0
2007-08-06 16:00:00	QQQ	ETF	47.99	48.03	47.88	47.98	3936253.0
2007-08-06 16:30:00	QQQ	ETF	47.98	48.01	47.95	47.97	149779.0

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

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