PREVIEW / etf_30min / 2008-05-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-20.parquet
  size:    171 KB
  rows:    5,964

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
2008-05-20 04:00:00	SPY	ETF	142.67	142.75	142.67	142.75	2800.0
2008-05-20 04:30:00	SPY	ETF	142.65	142.65	142.61	142.61	500.0
2008-05-20 05:00:00	SPY	ETF	142.59	142.59	142.57	142.57	800.0
2008-05-20 05:30:00	SPY	ETF	142.54	142.55	142.5	142.5	3200.0
2008-05-20 06:00:00	SPY	ETF	142.54	142.56	142.54	142.55	4000.0
2008-05-20 06:30:00	SPY	ETF	142.56	142.56	142.44	142.44	161700.0
2008-05-20 07:00:00	SPY	ETF	142.51	142.57	142.43	142.48	198450.0
2008-05-20 07:30:00	SPY	ETF	142.46	142.52	142.41	142.52	250125.0
2008-05-20 08:00:00	SPY	ETF	142.5	142.64	142.39	142.51	1812127.0
2008-05-20 08:30:00	SPY	ETF	142.38	142.58	142.04	142.16	3404150.0
2008-05-20 09:00:00	SPY	ETF	142.15	142.27	142.05	142.26	1296855.0
2008-05-20 09:30:00	SPY	ETF	142.27	142.34	141.85	141.87	16866232.0
2008-05-20 10:00:00	SPY	ETF	141.87	142.05	141.66	141.96	16735131.0
2008-05-20 10:30:00	SPY	ETF	141.97	142.03	141.63	141.97	12595761.0
2008-05-20 11:00:00	SPY	ETF	141.97	142.01	141.52	141.67	11563050.0
2008-05-20 11:30:00	SPY	ETF	141.67	141.72	141.37	141.501	9895888.0
2008-05-20 12:00:00	SPY	ETF	141.51	141.88	141.42	141.78	8655509.0
2008-05-20 12:30:00	SPY	ETF	141.78	141.92	141.47	141.58	6244272.0
2008-05-20 13:00:00	SPY	ETF	141.58	141.82	141.52	141.71	7200021.0
2008-05-20 13:30:00	SPY	ETF	141.72	141.73	141.0	141.27	12816045.0
2008-05-20 14:00:00	SPY	ETF	141.27	141.4	141.06	141.13	9491280.0
2008-05-20 14:30:00	SPY	ETF	141.12	141.43	141.11	141.23	8123400.0
2008-05-20 15:00:00	SPY	ETF	141.225	141.69	141.2	141.52	11465501.0
2008-05-20 15:30:00	SPY	ETF	141.52	142.0	141.06	141.64	22494428.0
2008-05-20 16:00:00	SPY	ETF	141.66	142.8489	141.45	141.81	4052802.0
2008-05-20 16:30:00	SPY	ETF	141.78	141.89	141.76	141.8	2194682.0
2008-05-20 17:00:00	SPY	ETF	141.76	142.849	141.73	141.78	3091620.0
2008-05-20 17:30:00	SPY	ETF	141.74	141.78	141.74	141.74	2095.0
2008-05-20 18:00:00	SPY	ETF	141.74	141.83	141.73	141.78	18345.0
2008-05-20 18:30:00	SPY	ETF	141.8	141.8	141.8	141.8	600.0
2008-05-20 19:00:00	SPY	ETF	141.77	141.87	141.77	141.84	4950.0
2008-05-20 19:30:00	SPY	ETF	141.8	141.81	141.72	141.72	6675.0
2008-05-20 06:30:00	QQQ	ETF	49.59	49.59	49.55	49.55	46500.0
2008-05-20 07:00:00	QQQ	ETF	49.55	49.58	49.54	49.58	24700.0
2008-05-20 07:30:00	QQQ	ETF	49.56	49.56	49.53	49.56	78866.0
2008-05-20 08:00:00	QQQ	ETF	49.57	49.61	49.46	49.51	557735.0
2008-05-20 08:30:00	QQQ	ETF	49.51	49.58	49.38	49.42	1286260.0
2008-05-20 09:00:00	QQQ	ETF	49.42	49.45	49.39	49.44	1285298.0
2008-05-20 09:30:00	QQQ	ETF	49.44	49.47	49.18	49.2018	21921714.0
2008-05-20 10:00:00	QQQ	ETF	49.2	49.25	49.07	49.2	14435026.0
2008-05-20 10:30:00	QQQ	ETF	49.21	49.21	49.0	49.2	9257926.0
2008-05-20 11:00:00	QQQ	ETF	49.21	49.21	48.92	49.08	10696181.0
2008-05-20 11:30:00	QQQ	ETF	49.07	49.09	48.96	49.01	6094861.0
2008-05-20 12:00:00	QQQ	ETF	49.02	49.26	48.99	49.2	5745948.0
2008-05-20 12:30:00	QQQ	ETF	49.21	49.29	49.0601	49.1482	4161684.0
2008-05-20 13:00:00	QQQ	ETF	49.15	49.28	49.07	49.17	4040384.0
2008-05-20 13:30:00	QQQ	ETF	49.1796	49.18	48.97	48.99	8881897.0
2008-05-20 14:00:00	QQQ	ETF	48.98	49.05	48.89	48.9696	9795490.0
2008-05-20 14:30:00	QQQ	ETF	48.9699	49.15	48.9518	49.02	5217229.0
2008-05-20 15:00:00	QQQ	ETF	49.0299	49.25	49.0	49.19	6699014.0

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

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