PREVIEW / etf_30min / 2007-06-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-11.parquet
  size:    116 KB
  rows:    4,363

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-06-11 05:00:00	SPY	ETF	150.86	150.86	150.86	150.86	100.0
2007-06-11 05:30:00	SPY	ETF	150.98	150.98	150.98	150.98	3200.0
2007-06-11 06:00:00	SPY	ETF	151.08	151.08	151.08	151.08	27500.0
2007-06-11 06:30:00	SPY	ETF	151.01	151.04	151.01	151.04	9000.0
2007-06-11 07:00:00	SPY	ETF	151.0	151.0	150.79	150.82	31900.0
2007-06-11 07:30:00	SPY	ETF	150.83	150.96	150.83	150.94	49800.0
2007-06-11 08:00:00	SPY	ETF	150.93	151.17	150.78	151.11	312100.0
2007-06-11 08:30:00	SPY	ETF	151.09	151.29	151.09	151.09	1686200.0
2007-06-11 09:00:00	SPY	ETF	151.21	151.21	149.6008	150.97	991000.0
2007-06-11 09:30:00	SPY	ETF	150.93	151.42	150.72	151.26	15402540.0
2007-06-11 10:00:00	SPY	ETF	151.26	151.28	150.73	150.81	11035710.0
2007-06-11 10:30:00	SPY	ETF	150.8	151.08	150.7	151.07	9050309.0
2007-06-11 11:00:00	SPY	ETF	151.06	151.26	150.99	151.09	4031200.0
2007-06-11 11:30:00	SPY	ETF	151.1	151.56	151.1	151.51	9876019.0
2007-06-11 12:00:00	SPY	ETF	151.51	151.57	151.37	151.45	2754400.0
2007-06-11 12:30:00	SPY	ETF	151.4474	151.73	150.9	151.65	5987000.0
2007-06-11 13:00:00	SPY	ETF	151.64	151.95	151.6	151.84	5621174.0
2007-06-11 13:30:00	SPY	ETF	151.84	151.85	151.6	151.63	3773273.0
2007-06-11 14:00:00	SPY	ETF	151.64	151.93	151.61	151.8	5312560.0
2007-06-11 14:30:00	SPY	ETF	151.8	151.8	151.27	151.68	6745100.0
2007-06-11 15:00:00	SPY	ETF	151.68	151.81	151.52	151.7	6263106.0
2007-06-11 15:30:00	SPY	ETF	151.69	151.7	151.18	151.3	9638778.0
2007-06-11 16:00:00	SPY	ETF	151.31	151.44	151.29	151.33	1432300.0
2007-06-11 16:30:00	SPY	ETF	151.34	151.39	151.31	151.38	659700.0
2007-06-11 17:00:00	SPY	ETF	151.38	151.4	151.31	151.31	128200.0
2007-06-11 17:30:00	SPY	ETF	151.37	151.41	151.34	151.34	25700.0
2007-06-11 18:00:00	SPY	ETF	151.34	151.35	151.33	151.35	466900.0
2007-06-11 18:30:00	SPY	ETF	151.35	151.35	151.32	151.32	10000.0
2007-06-11 19:00:00	SPY	ETF	151.3	151.3	151.3	151.3	2000.0
2007-06-11 19:30:00	SPY	ETF	151.3	151.33	151.3	151.32	1300.0
2007-06-11 06:30:00	QQQ	ETF	46.9	46.9	46.9	46.9	2000.0
2007-06-11 07:00:00	QQQ	ETF	46.87	46.87	46.83	46.83	9800.0
2007-06-11 07:30:00	QQQ	ETF	46.83	46.85	46.82	46.85	78969.0
2007-06-11 08:00:00	QQQ	ETF	46.86	46.95	46.86	46.92	158227.0
2007-06-11 08:30:00	QQQ	ETF	46.92	46.97	46.92	46.94	707440.0
2007-06-11 09:00:00	QQQ	ETF	46.93	46.94	46.85	46.89	2037439.0
2007-06-11 09:30:00	QQQ	ETF	46.89	47.08	46.83	47.0095	12436771.0
2007-06-11 10:00:00	QQQ	ETF	47.0	47.02	46.83	46.84	11235134.0
2007-06-11 10:30:00	QQQ	ETF	46.84	46.91	46.81	46.91	6359396.0
2007-06-11 11:00:00	QQQ	ETF	46.91	46.99	46.86	46.93	5338833.0
2007-06-11 11:30:00	QQQ	ETF	46.92	47.05	46.9	47.01	4834498.0
2007-06-11 12:00:00	QQQ	ETF	47.01	47.025	46.93	46.97	2530758.0
2007-06-11 12:30:00	QQQ	ETF	46.98	47.15	46.97	47.12	6459558.0
2007-06-11 13:00:00	QQQ	ETF	47.12	47.19	47.09	47.13	6108569.0
2007-06-11 13:30:00	QQQ	ETF	47.13	47.15	47.04	47.0597	5906217.0
2007-06-11 14:00:00	QQQ	ETF	47.0599	47.14	47.04	47.08	5024595.0
2007-06-11 14:30:00	QQQ	ETF	47.07	47.08	46.94	46.97	6980042.0
2007-06-11 15:00:00	QQQ	ETF	46.97	47.01	46.92	46.9515	5292132.0
2007-06-11 15:30:00	QQQ	ETF	46.95	46.96	46.76	46.82	11392884.0
2007-06-11 16:00:00	QQQ	ETF	46.82	46.89	46.8	46.88	1891846.0

> showing 50 of 4,363 rows — these rows as CSV

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