PREVIEW / etf_30min / 2007-06-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-06.parquet
  size:    117 KB
  rows:    4,466

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-06 06:00:00	SPY	ETF	152.82	152.82	152.82	152.82	100.0
2007-06-06 06:30:00	SPY	ETF	153.0	153.0	152.78	152.9	18000.0
2007-06-06 07:00:00	SPY	ETF	152.87	152.91	152.76	152.9	165200.0
2007-06-06 07:30:00	SPY	ETF	153.0	153.0	152.79	152.86	185900.0
2007-06-06 08:00:00	SPY	ETF	152.88	153.49	152.77	152.82	1377200.0
2007-06-06 08:30:00	SPY	ETF	152.82	152.94	152.64	152.86	1419500.0
2007-06-06 09:00:00	SPY	ETF	152.86	152.94	152.69	152.89	600200.0
2007-06-06 09:30:00	SPY	ETF	152.91	152.95	152.43	152.58	18821055.0
2007-06-06 10:00:00	SPY	ETF	152.58	152.9	152.23	152.55	15374558.0
2007-06-06 10:30:00	SPY	ETF	152.54	152.63	152.09	152.16	14333035.0
2007-06-06 11:00:00	SPY	ETF	152.16	152.45	152.11	152.29	8915700.0
2007-06-06 11:30:00	SPY	ETF	152.29	152.33	152.0	152.13	9347562.0
2007-06-06 12:00:00	SPY	ETF	152.12	152.44	152.1	152.3	7890860.0
2007-06-06 12:30:00	SPY	ETF	152.2999	152.36	152.0	152.04	5290300.0
2007-06-06 13:00:00	SPY	ETF	152.05	152.11	151.76	151.88	11367620.0
2007-06-06 13:30:00	SPY	ETF	151.88	152.01	151.85	152.01	9037672.0
2007-06-06 14:00:00	SPY	ETF	152.01	152.13	151.82	152.01	8408491.0
2007-06-06 14:30:00	SPY	ETF	152.0	152.79	151.96	152.12	7130678.0
2007-06-06 15:00:00	SPY	ETF	152.12	152.35	151.96	152.25	10575705.0
2007-06-06 15:30:00	SPY	ETF	152.24	152.4	152.09	152.1	14422379.0
2007-06-06 16:00:00	SPY	ETF	152.09	152.13	151.75	151.94	7058100.0
2007-06-06 16:30:00	SPY	ETF	151.94	151.94	151.84	151.86	1380000.0
2007-06-06 17:00:00	SPY	ETF	151.89	151.89	151.84	151.89	9300.0
2007-06-06 17:30:00	SPY	ETF	151.88	151.88	151.88	151.88	11100.0
2007-06-06 18:00:00	SPY	ETF	151.88	151.89	151.84	151.88	25400.0
2007-06-06 18:30:00	SPY	ETF	151.88	151.88	151.88	151.88	100.0
2007-06-06 19:00:00	SPY	ETF	151.89	152.01	151.89	152.01	13200.0
2007-06-06 19:30:00	SPY	ETF	152.0	152.09	152.0	152.09	5000.0
2007-06-06 05:00:00	QQQ	ETF	47.38	47.38	47.37	47.37	5000.0
2007-06-06 05:30:00	QQQ	ETF	47.38	47.38	47.35	47.35	7000.0
2007-06-06 06:00:00	QQQ	ETF	47.33	47.33	47.32	47.32	500.0
2007-06-06 06:30:00	QQQ	ETF	47.3	47.32	47.3	47.31	97400.0
2007-06-06 07:00:00	QQQ	ETF	47.31	47.37	47.27	47.37	612912.0
2007-06-06 07:30:00	QQQ	ETF	47.37	47.37	47.31	47.31	294113.0
2007-06-06 08:00:00	QQQ	ETF	47.33	47.36	47.29	47.3	444419.0
2007-06-06 08:30:00	QQQ	ETF	47.3	47.37	47.25	47.32	1891144.0
2007-06-06 09:00:00	QQQ	ETF	47.32	47.38	47.32	47.37	1224000.0
2007-06-06 09:30:00	QQQ	ETF	47.37	47.38	47.16	47.3	31637022.0
2007-06-06 10:00:00	QQQ	ETF	47.3	47.31	47.08	47.26	19811418.0
2007-06-06 10:30:00	QQQ	ETF	47.26	47.28	47.1	47.1	14505280.0
2007-06-06 11:00:00	QQQ	ETF	47.1	47.23	47.07	47.1699	8012253.0
2007-06-06 11:30:00	QQQ	ETF	47.16	47.2	47.08	47.11	8081497.0
2007-06-06 12:00:00	QQQ	ETF	47.11	47.24	47.1	47.18	11907931.0
2007-06-06 12:30:00	QQQ	ETF	47.17	47.19	47.07	47.09	6623896.0
2007-06-06 13:00:00	QQQ	ETF	47.09	47.11	46.9614	47.03	14204884.0
2007-06-06 13:30:00	QQQ	ETF	47.03	47.11	47.02	47.11	4974392.0
2007-06-06 14:00:00	QQQ	ETF	47.11	47.15	47.04	47.12	6500501.0
2007-06-06 14:30:00	QQQ	ETF	47.12	47.19	47.11	47.15	7470880.0
2007-06-06 15:00:00	QQQ	ETF	47.15	47.25	47.08	47.2	13288624.0
2007-06-06 15:30:00	QQQ	ETF	47.19	47.26	47.11	47.11	15024617.0

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

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