PREVIEW / etf_30min / 2007-11-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-16.parquet
  size:    138 KB
  rows:    5,087

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-11-16 05:00:00	SPY	ETF	145.5	145.5	145.5	145.5	1800.0
2007-11-16 05:30:00	SPY	ETF	145.35	145.72	145.35	145.72	5200.0
2007-11-16 06:00:00	SPY	ETF	145.7	145.93	145.7	145.93	129000.0
2007-11-16 06:30:00	SPY	ETF	145.82	145.84	145.76	145.76	25100.0
2007-11-16 07:00:00	SPY	ETF	145.69	146.34	145.65	146.34	811900.0
2007-11-16 07:30:00	SPY	ETF	146.34	146.35	146.14	146.22	427200.0
2007-11-16 08:00:00	SPY	ETF	146.21	146.46	145.68	146.22	3642300.0
2007-11-16 08:30:00	SPY	ETF	146.22	146.49	145.78	146.44	1875300.0
2007-11-16 09:00:00	SPY	ETF	146.43	146.43	146.0	146.28	3003800.0
2007-11-16 09:30:00	SPY	ETF	146.28	146.43	145.29	145.31	28561990.0
2007-11-16 10:00:00	SPY	ETF	145.31	145.68	144.72	144.73	41542915.0
2007-11-16 10:30:00	SPY	ETF	144.74	145.24	144.57	145.02	18178376.0
2007-11-16 11:00:00	SPY	ETF	145.02	145.62	144.97	145.01	15667007.0
2007-11-16 11:30:00	SPY	ETF	145.0	146.02	145.0	145.74	17182175.0
2007-11-16 12:00:00	SPY	ETF	145.74	146.47	145.65	146.0	17286494.0
2007-11-16 12:30:00	SPY	ETF	146.0	146.2	145.57	145.66	12676923.0
2007-11-16 13:00:00	SPY	ETF	145.66	146.17	145.62	145.72	8547181.0
2007-11-16 13:30:00	SPY	ETF	145.7	146.29	145.66	145.79	8217175.0
2007-11-16 14:00:00	SPY	ETF	145.8	145.82	145.0	145.4001	26828377.0
2007-11-16 14:30:00	SPY	ETF	145.4	145.56	144.62	145.24	29881088.0
2007-11-16 15:00:00	SPY	ETF	145.24	146.0	145.01	145.24	13020905.0
2007-11-16 15:30:00	SPY	ETF	145.23	146.17	144.92	146.04	36135562.0
2007-11-16 16:00:00	SPY	ETF	146.02	146.05	144.88	145.86	8260500.0
2007-11-16 16:30:00	SPY	ETF	145.3227	145.95	145.3227	145.78	3559500.0
2007-11-16 17:00:00	SPY	ETF	145.8	145.82	145.44	145.79	2112200.0
2007-11-16 17:30:00	SPY	ETF	145.79	145.88	145.78	145.84	1843500.0
2007-11-16 18:00:00	SPY	ETF	145.83	145.89	145.83	145.89	22600.0
2007-11-16 18:30:00	SPY	ETF	145.92	146.03	145.89	145.99	15900.0
2007-11-16 19:00:00	SPY	ETF	145.95	145.98	145.94	145.98	1700.0
2007-11-16 19:30:00	SPY	ETF	145.98	146.02	145.95	146.02	2400.0
2007-11-16 05:30:00	QQQ	ETF	49.75	49.75	49.75	49.75	700.0
2007-11-16 07:00:00	QQQ	ETF	49.8	50.13	49.8	50.04	945896.0
2007-11-16 07:30:00	QQQ	ETF	50.08	50.09	50.01	50.06	477389.0
2007-11-16 08:00:00	QQQ	ETF	50.06	50.24	49.92	50.17	2491785.0
2007-11-16 08:30:00	QQQ	ETF	50.17	50.36	50.14	50.35	4230694.0
2007-11-16 09:00:00	QQQ	ETF	50.35	50.35	50.14	50.14	5488384.0
2007-11-16 09:30:00	QQQ	ETF	50.13	50.17	49.5	49.54	50889159.0
2007-11-16 10:00:00	QQQ	ETF	49.53	49.74	49.4	49.4	31272874.0
2007-11-16 10:30:00	QQQ	ETF	49.4	49.68	49.34	49.6215	12815340.0
2007-11-16 11:00:00	QQQ	ETF	49.61	49.96	49.61	49.76	18539892.0
2007-11-16 11:30:00	QQQ	ETF	49.76	50.27	49.75	50.13	23380183.0
2007-11-16 12:00:00	QQQ	ETF	50.1301	50.36	50.1	50.12	11190808.0
2007-11-16 12:30:00	QQQ	ETF	50.12	50.21	49.94	50.0	11444333.0
2007-11-16 13:00:00	QQQ	ETF	50.0	50.15	49.94	50.01	5397682.0
2007-11-16 13:30:00	QQQ	ETF	50.0	50.25	49.97	50.09	6631480.0
2007-11-16 14:00:00	QQQ	ETF	50.08	50.12	49.76	50.11	16231464.0
2007-11-16 14:30:00	QQQ	ETF	50.12	50.15	49.8	50.05	9687698.0
2007-11-16 15:00:00	QQQ	ETF	50.05	50.13	49.95	50.02	11087154.0
2007-11-16 15:30:00	QQQ	ETF	50.02	50.49	49.96	50.34	26612548.0
2007-11-16 16:00:00	QQQ	ETF	50.34	50.5035	49.7774	50.38	14175807.0

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

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