PREVIEW / etf_30min / 2009-11-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-13.parquet
  size:    228 KB
  rows:    7,578

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
2009-11-13 04:00:00	SPY	ETF	109.56	109.6	109.52	109.6	1950.0
2009-11-13 04:30:00	SPY	ETF	109.52	109.55	109.52	109.55	600.0
2009-11-13 05:00:00	SPY	ETF	109.45	109.49	109.45	109.49	600.0
2009-11-13 05:30:00	SPY	ETF	109.47	109.47	109.47	109.47	300.0
2009-11-13 06:00:00	SPY	ETF	109.57	109.7	109.57	109.7	3400.0
2009-11-13 06:30:00	SPY	ETF	109.6	109.67	109.59	109.6	5650.0
2009-11-13 07:00:00	SPY	ETF	109.66	109.66	109.35	109.35	273949.0
2009-11-13 07:30:00	SPY	ETF	109.35	109.54	109.35	109.42	564777.0
2009-11-13 08:00:00	SPY	ETF	109.58	109.58	109.3	109.43	1352412.0
2009-11-13 08:30:00	SPY	ETF	109.45	109.57	108.99	109.52	948849.0
2009-11-13 09:00:00	SPY	ETF	109.52	109.57	109.24	109.32	970555.0
2009-11-13 09:30:00	SPY	ETF	109.31	109.45	108.75	108.89	29455455.0
2009-11-13 10:00:00	SPY	ETF	108.89	109.5	108.78	109.31	15592260.0
2009-11-13 10:30:00	SPY	ETF	109.31	109.84	109.16	109.63	14395910.0
2009-11-13 11:00:00	SPY	ETF	109.63	109.75	109.53	109.65	6846670.0
2009-11-13 11:30:00	SPY	ETF	109.65	109.83	109.51	109.51	5717986.0
2009-11-13 12:00:00	SPY	ETF	109.52	110.05	109.52	109.98	9969177.0
2009-11-13 12:30:00	SPY	ETF	109.99	110.09	109.88	109.94	5835046.0
2009-11-13 13:00:00	SPY	ETF	109.95	109.99	109.85	109.961	3887748.0
2009-11-13 13:30:00	SPY	ETF	109.9601	109.98	109.69	109.74	4992953.0
2009-11-13 14:00:00	SPY	ETF	109.74	109.85	109.54	109.6	6975792.0
2009-11-13 14:30:00	SPY	ETF	109.6	109.6	109.17	109.21	10925230.0
2009-11-13 15:00:00	SPY	ETF	109.21	109.65	109.1	109.385	9125140.0
2009-11-13 15:30:00	SPY	ETF	109.38	109.73	109.34	109.63	16431722.0
2009-11-13 16:00:00	SPY	ETF	109.63	109.9	108.94	109.7	4912090.0
2009-11-13 16:30:00	SPY	ETF	109.7	109.76	108.9993	109.76	1179189.0
2009-11-13 17:00:00	SPY	ETF	109.72	109.8	109.67	109.68	60031.0
2009-11-13 17:30:00	SPY	ETF	109.68	109.72	109.67	109.69	10050.0
2009-11-13 18:00:00	SPY	ETF	109.71	109.8	109.7	109.78	13130.0
2009-11-13 18:30:00	SPY	ETF	109.73	109.78	109.72	109.78	800.0
2009-11-13 19:00:00	SPY	ETF	109.78	109.8	109.77	109.8	3335.0
2009-11-13 19:30:00	SPY	ETF	109.78	109.83	109.78	109.81	9447.0
2009-11-13 04:30:00	QQQ	ETF	43.79	43.79	43.79	43.79	400.0
2009-11-13 06:30:00	QQQ	ETF	43.8	43.86	43.8	43.84	4176.0
2009-11-13 07:00:00	QQQ	ETF	43.82	43.84	43.75	43.76	15276.0
2009-11-13 07:30:00	QQQ	ETF	43.76	43.82	43.76	43.78	358986.0
2009-11-13 08:00:00	QQQ	ETF	43.79	43.79	43.73	43.77	989110.0
2009-11-13 08:30:00	QQQ	ETF	43.77	43.84	43.74	43.81	298848.0
2009-11-13 09:00:00	QQQ	ETF	43.82	43.84	43.72	43.78	646644.0
2009-11-13 09:30:00	QQQ	ETF	43.78	43.87	43.63	43.69	14633637.0
2009-11-13 10:00:00	QQQ	ETF	43.685	43.92	43.65	43.85	9821889.0
2009-11-13 10:30:00	QQQ	ETF	43.84	43.99	43.79	43.92	8960279.0
2009-11-13 11:00:00	QQQ	ETF	43.92	44.0	43.89	43.96	3567644.0
2009-11-13 11:30:00	QQQ	ETF	43.96	44.01	43.89	43.9	3809864.0
2009-11-13 12:00:00	QQQ	ETF	43.9	44.1	43.89	44.06	4675240.0
2009-11-13 12:30:00	QQQ	ETF	44.07	44.14	44.04	44.07	3323803.0
2009-11-13 13:00:00	QQQ	ETF	44.06	44.095	44.05	44.08	2429553.0
2009-11-13 13:30:00	QQQ	ETF	44.08	44.085	43.98	44.0025	2587258.0
2009-11-13 14:00:00	QQQ	ETF	44.0001	44.06	43.96	43.96	4230342.0
2009-11-13 14:30:00	QQQ	ETF	43.97	43.97	43.82	43.82	6572038.0

> showing 50 of 7,578 rows — these rows as CSV

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