PREVIEW / etf_30min / 2009-08-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-28.parquet
  size:    225 KB
  rows:    7,365

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-08-28 04:00:00	SPY	ETF	103.51	103.71	103.51	103.71	1950.0
2009-08-28 04:30:00	SPY	ETF	103.68	103.76	103.68	103.76	1541.0
2009-08-28 05:00:00	SPY	ETF	103.78	103.82	103.78	103.82	4447.0
2009-08-28 05:30:00	SPY	ETF	103.79	103.79	103.77	103.77	3500.0
2009-08-28 06:00:00	SPY	ETF	103.79	103.82	103.78	103.79	700.0
2009-08-28 06:30:00	SPY	ETF	103.8	103.92	103.8	103.92	700.0
2009-08-28 07:00:00	SPY	ETF	103.9	104.07	103.87	104.06	307716.0
2009-08-28 07:30:00	SPY	ETF	104.03	104.06	103.82	103.84	465315.0
2009-08-28 08:00:00	SPY	ETF	103.83	103.95	103.8	103.84	849088.0
2009-08-28 08:30:00	SPY	ETF	103.79	104.0	103.68	103.75	1446271.0
2009-08-28 09:00:00	SPY	ETF	103.76	104.33	103.76	104.23	3041842.0
2009-08-28 09:30:00	SPY	ETF	104.23	104.35	103.49	103.52	26756250.0
2009-08-28 10:00:00	SPY	ETF	103.52	103.76	103.2	103.27	15944071.0
2009-08-28 10:30:00	SPY	ETF	103.27	103.63	103.14	103.49	12358577.0
2009-08-28 11:00:00	SPY	ETF	103.49	103.56	103.27	103.44	6158808.0
2009-08-28 11:30:00	SPY	ETF	103.44	103.46	103.08	103.17	6100309.0
2009-08-28 12:00:00	SPY	ETF	103.18	103.29	102.67	102.76	9293479.0
2009-08-28 12:30:00	SPY	ETF	102.76	102.96	102.73	102.8	6538538.0
2009-08-28 13:00:00	SPY	ETF	102.8	103.22	102.79	103.12	5874072.0
2009-08-28 13:30:00	SPY	ETF	103.13	103.21	103.04	103.09	5070278.0
2009-08-28 14:00:00	SPY	ETF	103.09	103.35	102.99	103.21	6386277.0
2009-08-28 14:30:00	SPY	ETF	103.21	103.3	102.99	103.255	6567175.0
2009-08-28 15:00:00	SPY	ETF	103.25	103.45	103.14	103.34	5797033.0
2009-08-28 15:30:00	SPY	ETF	103.35	103.43	103.01	103.33	16546064.0
2009-08-28 16:00:00	SPY	ETF	103.34	103.4	103.06	103.13	6057004.0
2009-08-28 16:30:00	SPY	ETF	103.1	103.38	103.05	103.1	1215311.0
2009-08-28 17:00:00	SPY	ETF	103.1	103.13	103.06	103.06	26659.0
2009-08-28 17:30:00	SPY	ETF	103.06	103.4713	103.06	103.08	1019539.0
2009-08-28 18:00:00	SPY	ETF	103.1	103.33	103.06	103.09	14468.0
2009-08-28 18:30:00	SPY	ETF	103.1	103.11	103.08	103.08	7865.0
2009-08-28 19:00:00	SPY	ETF	103.1	103.11	103.09	103.11	4150.0
2009-08-28 19:30:00	SPY	ETF	103.11	103.15	103.11	103.11	29343.0
2009-08-28 06:00:00	QQQ	ETF	40.56	40.56	40.51	40.56	5100.0
2009-08-28 06:30:00	QQQ	ETF	40.52	40.56	40.52	40.56	1191.0
2009-08-28 07:00:00	QQQ	ETF	40.55	40.59	40.54	40.57	8739.0
2009-08-28 07:30:00	QQQ	ETF	40.59	40.6	40.51	40.54	118032.0
2009-08-28 08:00:00	QQQ	ETF	40.53	40.56	40.5	40.51	433901.0
2009-08-28 08:30:00	QQQ	ETF	40.51	40.62	40.4	40.57	4314667.0
2009-08-28 09:00:00	QQQ	ETF	40.58	40.93	40.57	40.88	7406740.0
2009-08-28 09:30:00	QQQ	ETF	40.88	41.08	40.63	40.66	22048401.0
2009-08-28 10:00:00	QQQ	ETF	40.66	40.78	40.43	40.5	11654300.0
2009-08-28 10:30:00	QQQ	ETF	40.5	40.6601	40.42	40.61	6284034.0
2009-08-28 11:00:00	QQQ	ETF	40.608	40.62	40.5	40.59	3650890.0
2009-08-28 11:30:00	QQQ	ETF	40.58	40.6	40.42	40.47	4027634.0
2009-08-28 12:00:00	QQQ	ETF	40.47	40.51	40.18	40.2099	7293448.0
2009-08-28 12:30:00	QQQ	ETF	40.21	40.27	40.16	40.17	4412395.0
2009-08-28 13:00:00	QQQ	ETF	40.18	40.41	40.17	40.36	4762121.0
2009-08-28 13:30:00	QQQ	ETF	40.35	40.4	40.32	40.34	2095135.0
2009-08-28 14:00:00	QQQ	ETF	40.34	40.46	40.3	40.4203	3911833.0
2009-08-28 14:30:00	QQQ	ETF	40.43	40.5	40.35	40.48	2488537.0

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

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